eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_WF dependencies on OE_ORDER_HOLDS

Line 186: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

182:
183: -- Getting the number of credit failure holds on this order
184: SELECT count(*)
185: INTO l_hold_count
186: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
187: WHERE H.HEADER_ID = l_header_id
188: -- AND H.LINE_ID IS NULL
189: AND H.HOLD_RELEASE_ID IS NULL
190: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID

Line 481: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

477: /*-------------------- Checking if the hold still exists -------------------*/
478:
479: SELECT count(*)
480: INTO l_hold_count
481: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
482: WHERE H.HEADER_ID = l_hold_entity_id
483: -- AND H.LINE_ID IS NULL
484: AND H.HOLD_RELEASE_ID IS NULL
485: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID

Line 850: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

846: l_manual_release NUMBER := 0; -- no. of times credit hold was manually released
847: l_hold_release_id NUMBER := 0; -- release ID for the last credit hold
848: CURSOR released_hold IS
849: SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
850: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
851: WHERE H.HEADER_ID = header_id
852: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
853: AND H.HOLD_RELEASE_ID IS NOT NULL
854: AND S.HOLD_ID = 1