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.GML_RCV_TXN_INTERFACE dependencies on PO_HEADERS

Line 52: po_headers ph,

48: , pl.item_revision --only needed for std_deliver
49: FROM
50: po_line_locations pll,
51: po_lines pl,
52: po_headers ph,
53: rcv_shipment_lines rsl,
54: (SELECT DISTINCT source_line_id
55: FROM wms_lpn_contents
56: WHERE parent_lpn_id = v_lpn_id) wlc

Line 106: po_headers ph,

102: SELECT COUNT(*)
103: FROM
104: po_line_locations pll,
105: po_lines pl,
106: po_headers ph,
107: rcv_shipment_lines rsl,
108: (SELECT DISTINCT source_line_id
109: FROM wms_lpn_contents
110: WHERE parent_lpn_id = v_lpn_id) wlc

Line 173: po_headers ph,

169: , pl.item_revision --only needed for std_deliver
170: FROM
171: po_line_locations pll,
172: po_lines pl,
173: po_headers ph,
174: rcv_shipment_lines rsl,
175: (SELECT DISTINCT source_line_id
176: FROM wms_lpn_contents
177: WHERE parent_lpn_id = v_lpn_id) wlc

Line 231: po_headers ph,

227: SELECT COUNT(*)
228: FROM
229: po_line_locations pll,
230: po_lines pl,
231: po_headers ph,
232: rcv_shipment_lines rsl,
233: (SELECT DISTINCT source_line_id
234: FROM wms_lpn_contents
235: WHERE parent_lpn_id = v_lpn_id) wlc

Line 298: po_headers_all ph

294: , 0 rcv_transaction_id -- only need it for std_deliver
295: , pl.item_revision --only needed for std_deliver
296: from po_line_locations_all pll,
297: po_lines_all pl,
298: po_headers_all ph
299: where ph.po_header_id = header_id
300: and pll.po_header_id = header_id
301: AND pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
302: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)

Line 408: po_headers ph

404: ,pl.item_revision --only needed for std_deliver
405: from po_distributions pod,
406: po_line_locations pll,
407: po_lines pl,
408: po_headers ph
409: where ph.po_header_id = header_id
410: and pod.po_header_id = header_id
411: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
412: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)

Line 515: po_headers ph,

511: ,rs.item_revision
512: from po_distributions pod,
513: po_line_locations pll,
514: po_lines pl,
515: po_headers ph,
516: rcv_supply rs,
517: rcv_shipment_headers rsh,
518: -- rcv_shipment_lines rsl,
519: rcv_transactions rt

Line 592: po_headers ph,

588: select count(*)
589: from po_distributions pod,
590: po_line_locations pll,
591: po_lines pl,
592: po_headers ph,
593: rcv_supply rs,
594: rcv_shipment_headers rsh,
595: -- rcv_shipment_lines rsl,
596: rcv_transactions rt