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 561: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id

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

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

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