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 517: oe_order_holds_all ohld,

513: ,ohdr.org_id
514: ,ohdr.order_source_id
515: ,ohld.released_flag
516: FROM oe_order_headers_all ohdr,
517: oe_order_holds_all ohld,
518: oe_order_sources osrc -- to remove hardcoding on order_source_id
519: WHERE ohdr.header_id = ohld.header_id
520: -- AND ohdr.order_source_id = 28
521: AND ohdr.order_source_id = osrc.order_source_id

Line 533: FROM oe_order_holds ooh,

529:
530: CURSOR get_ord_hld_cur IS
531: SELECT ooh.header_id
532: ,ooh.line_id
533: FROM oe_order_holds ooh,
534: oe_order_headers_all h,
535: oe_order_sources osrc -- to remove hardcoding on order_source_id
536: WHERE h.header_id = ooh.header_id
537: -- AND h.order_source_id = 28