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.GMPMPACT dependencies on INV_SALESORDER

Line 563: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id

559: SELECT DISTINCT oh.order_number
560: FROM oe_order_headers_all oh,
561: oe_order_lines_all ol
562: WHERE oh.header_id = ol.header_id
563: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id
564: AND ol.open_flag = 'Y'
565: AND ol.visible_demand_flag = 'Y' /*B4905079 - Flag to ensure that available_to_mrp = 1 */
566: AND decode(ol.source_document_type_id, 10, 8, decode(ol.line_category_code, 'ORDER',2,12)) IN (2,8);
567:

Line 576: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id

572: SELECT DISTINCT oh.order_number
573: FROM oe_order_headers_all oh,
574: oe_order_lines_all ol
575: WHERE oh.header_id = ol.header_id
576: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id
577: AND ol.open_flag = 'Y'
578: AND ol.visible_demand_flag = 'Y' /*B4905079 - Flag to ensure that available_to_mrp = 1 */
579: AND decode(ol.source_document_type_id, 10, 8, decode(ol.line_category_code, 'ORDER',2,12)) IN (2,8)
580: AND nvl(ol.source_document_type_id, 0) <> 10 ;