APPS.GML_RCV_TXN_INTERFACE dependencies on RCV_SHIPMENT_LINES

Line 53: rcv_shipment_lines rsl,

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
57: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)

Line 107: rcv_shipment_lines rsl,

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
111: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)

Line 174: rcv_shipment_lines rsl,

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
178: WHERE ph.po_header_id = header_id

Line 232: rcv_shipment_lines rsl,

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
236: WHERE ph.po_header_id = header_id

Line 518: -- rcv_shipment_lines rsl,

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
520: where rsh.receipt_source_code = 'VENDOR'
521: AND ph.po_header_id = header_id
522: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)

Line 595: -- rcv_shipment_lines rsl,

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
597: where rsh.receipt_source_code = 'VENDOR'
598: AND ph.po_header_id = header_id
599: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)