Translate

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
- No comments:


Oracle EBs Apps Blog of Mahfuz, OPM Consultant, Bangladesh.

 

 

http://mahfuzgeml.blogspot.com/2015/12/opm-formula-to-execution-work-flow.html

- No comments:
Subscribe to: Posts (Atom)

Outside Processing Setups and Cycle in Oracle EBS R12

  OSP Cycle This post is about Oracle Outside Processing Cycle. Outside processing is used when we don't have in house resources to comp...