Monday, March 27, 2017
PROD_Batch_ Status_Query
SELECT o.ORGANIZATION_CODE, o.ORGANIZATION_NAME, o.ORGANIZATION_ID,
gbh.BATCH_NO,decode(gbh.BATCH_STATUS,3,'Completed') Batch_Status
FROM GME_BATCH_HEADER gbh,
ORG_ORGANIZATION_DEFINITIONS o
WHERE CREATION_DATE between TO_DATE('01-Feb-2017','DD-MM-YYYY') and TO_DATE('28-Feb-2017','DD-MM-YYYY')
AND gbh.ORGANIZATION_ID=o.ORGANIZATION_ID
ORDER BY BATCH_STATUS, o.ORGANIZATION_CODE
Subscribe to:
Post Comments (Atom)
-
Oracle Alert : Move order Created from Production Batch I Got one Requirement from Production and Store Team, as below So I created... -
Oracle Process Manufacturing Process Execution – List of database tables GME_BATCH_HEADER GME_BATCH_HEADER_MIG GME_BATCH_HISTORY GME_BATCH_...
-
Discrete Jobs End to End Cycle with Cost Roll-up in Standard Cost Organization in R12.2 STEP 1: CREATE ITEMS Responsibility: ...
No comments:
Post a Comment
Text Message