APPS.GML_RCV_TXN_INTERFACE dependencies on WMS_LPN_CONTENTS

Line 55: FROM wms_lpn_contents

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)
58: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)
59: AND Nvl(pll.po_release_id,0) = Nvl(v_po_release_id,Nvl(pll.po_release_id,0))

Line 109: FROM wms_lpn_contents

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)
112: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)
113: AND Nvl(pll.po_release_id,0) = Nvl(v_po_release_id,Nvl(pll.po_release_id,0))

Line 176: FROM wms_lpn_contents

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
179: AND pll.po_header_id = header_id
180: AND pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)

Line 234: FROM wms_lpn_contents

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
237: AND pll.po_header_id = header_id
238: AND pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)