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.GMF_INTERNAL_ORDERS dependencies on IC_TRAN_PND

Line 35: ic_tran_pnd t

31: DECODE(NVL(min(t.invoiced_flag),'-1'),'-1',0,'P',2,1)
32: FROM po_requisition_headers_all prh,
33: po_requisition_lines_all prl,
34: oe_order_lines_all oel,
35: ic_tran_pnd t
36: WHERE prl.requisition_header_id = prh.requisition_header_id
37: and prh.segment1 = oel.orig_sys_document_ref
38: and prl.requisition_line_id = oel.source_document_line_id
39: and oel.order_source_id = 10

Line 117: ic_tran_pnd t

113: SELECT max(t.trans_id)
114: FROM po_requisition_headers_all prh,
115: po_requisition_lines_all prl,
116: oe_order_lines_all oel,
117: ic_tran_pnd t
118: WHERE prl.requisition_header_id = prh.requisition_header_id
119: and prh.segment1 = oel.orig_sys_document_ref
120: and prl.requisition_line_id = oel.source_document_line_id
121: and oel.order_source_id = 10

Line 129: ,ic_tran_pnd pnd

125: and t.delete_mark = 0
126: and oel.inventory_item_id = cp_inv_item_id
127: and prl.requisition_line_id = (SELECT t.requisition_line_id
128: FROM rcv_transactions t
129: ,ic_tran_pnd pnd
130: WHERE t.shipment_header_id = pnd.doc_id
131: and t.transaction_id = pnd.line_id
132: and pnd.doc_type = 'PORC'
133: and pnd.completed_ind = 1