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_SOURCES

Line 518: oe_order_sources osrc -- to remove hardcoding on order_source_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
522: and osrc.aia_enabled_flag = 'Y'

Line 535: oe_order_sources osrc -- to remove hardcoding on order_source_id

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
538: AND h.order_source_id = osrc.order_source_id
539: AND osrc.aia_enabled_flag = 'Y'