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_CHECK_LINES_PVT dependencies on OE_ORDER_HOLDS

Line 678: FROM OE_ORDER_HOLDS h,

674: IF p_credit_hold_level = 'ORDER'
675: THEN
676: SELECT /* MOAC_SQL_CHANGE */ NVL(MAX(H.HOLD_RELEASE_ID),0)
677: INTO l_hold_release_id
678: FROM OE_ORDER_HOLDS h,
679: OE_HOLD_SOURCES_ALL s
680: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
681: AND H.HEADER_ID = p_header_id
682: AND H.LINE_ID IS NULL

Line 691: FROM OE_ORDER_HOLDS h,

687: AND S.RELEASED_FLAG ='Y';
688: ELSE
689: SELECT /* MOAC_SQL_CHANGE */ NVL(MAX(H.HOLD_RELEASE_ID),0)
690: INTO l_hold_release_id
691: FROM OE_ORDER_HOLDS h,
692: OE_HOLD_SOURCES_ALL s
693: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
694: AND H.HEADER_ID = p_header_id
695: AND H.LINE_ID = p_line_id

Line 3857: FROM oe_order_holds_all oh,

3853: OR l.payment_type_code IS NULL
3854: )
3855: AND (EXISTS
3856: (SELECT 'Y'
3857: FROM oe_order_holds_all oh,
3858: oe_hold_sources_all hs
3859: WHERE oh.header_id = p_header_rec.header_id
3860: AND oh.line_id = l.line_id
3861: AND oh.hold_release_id IS NULL