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 192: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

188:
189: -- Getting the number of credit failure holds on this order
190: SELECT count(*)
191: INTO l_hold_count
192: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
193: WHERE H.HEADER_ID = l_header_id
194: -- AND H.LINE_ID IS NULL
195: AND H.HOLD_RELEASE_ID IS NULL
196: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID

Line 487: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

483: /*-------------------- Checking if the hold still exists -------------------*/
484:
485: SELECT count(*)
486: INTO l_hold_count
487: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
488: WHERE H.HEADER_ID = l_hold_entity_id
489: -- AND H.LINE_ID IS NULL
490: AND H.HOLD_RELEASE_ID IS NULL
491: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID

Line 857: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

853: l_hold_release_id NUMBER := 0; -- release ID for the last credit hold
854: CURSOR released_hold IS
855: --added for BUG#9728597 Start
856: SELECT ohr.HOLD_RELEASE_ID
857: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
858: ,oe_hold_releases ohr
859: WHERE H.HEADER_ID = header_id
860: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
861: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 872: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S

868: --added for BUG#9728597 End
869:
870: --commented for BUG#9728597
871: /* SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
872: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
873: WHERE H.HEADER_ID = header_id
874: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
875: AND H.HOLD_RELEASE_ID IS NOT NULL
876: AND S.HOLD_ID = 1