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

Line 458: oe_order_holds_all ohld

454: ,ohdr.org_id
455: ,ohdr.order_source_id
456: ,ohld.released_flag
457: FROM oe_order_headers_all ohdr,
458: oe_order_holds_all ohld
459: WHERE ohdr.header_id = ohld.header_id
460: AND ohdr.order_source_id = 28
461: AND ohld.hold_source_id = p_hold_source_id
462: AND decode(p_change_type,'RELEASE',ohld.hold_release_id,-99)

Line 471: FROM oe_order_holds ooh,

467:
468: CURSOR get_ord_hld_cur IS
469: SELECT ooh.header_id
470: ,ooh.line_id
471: FROM oe_order_holds ooh,
472: oe_order_headers_all h
473: WHERE h.header_id = ooh.header_id
474: AND h.order_source_id = 28
475: AND ooh.order_hold_id = p_order_hold_id;