APPS.INV_RCV_TXN_INTERFACE dependencies on WMS_LPN_CONTENTS

Line 78: FROM wms_lpn_contents

74: -- Bug 3444226 The Join with po_headers is unnecessary
75: -- po_headers ph,
76: rcv_shipment_lines rsl,
77: (SELECT DISTINCT source_line_id
78: FROM wms_lpn_contents
79: WHERE parent_lpn_id = v_lpn_id) wlc
80: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
81: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)
82: AND Nvl(pll.po_release_id,0) = Nvl(v_po_release_id,Nvl(pll.po_release_id,0))

Line 143: FROM wms_lpn_contents

139: -- Bug 3444226 The Join with po_headers is unnecessary
140: -- po_headers ph,
141: rcv_shipment_lines rsl,
142: (SELECT DISTINCT source_line_id
143: FROM wms_lpn_contents
144: WHERE parent_lpn_id = v_lpn_id) wlc
145: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
146: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)
147: AND Nvl(pll.po_release_id,0) = Nvl(v_po_release_id,Nvl(pll.po_release_id,0))

Line 221: FROM wms_lpn_contents

217: -- Bug 3444226 The Join with po_headers is unnecessary
218: -- po_headers ph,
219: rcv_shipment_lines rsl,
220: (SELECT DISTINCT source_line_id
221: FROM wms_lpn_contents
222: WHERE parent_lpn_id = v_lpn_id) wlc
223: -- Bug 3444226 The condition with po_headers is unnecessary
224: -- WHERE ph.po_header_id = header_id
225: WHERE pll.po_header_id = header_id

Line 291: FROM wms_lpn_contents

287: -- Bug 3444226 The Join with po_headers is unnecessary
288: -- po_headers ph,
289: rcv_shipment_lines rsl,
290: (SELECT DISTINCT source_line_id
291: FROM wms_lpn_contents
292: WHERE parent_lpn_id = v_lpn_id) wlc
293: -- Bug 3444226 The Join with po_headers is unnecessary
294: -- WHERE ph.po_header_id = header_id
295: WHERE pll.po_header_id = header_id

Line 373: FROM wms_lpn_contents

369: -- Bug 3444226 The Join with po_headers is unnecessary
370: -- po_headers ph,
371: rcv_shipment_lines rsl,
372: (SELECT DISTINCT source_line_id
373: FROM wms_lpn_contents
374: WHERE parent_lpn_id = v_lpn_id) wlc
375: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
376: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)
377: AND Nvl(pll.po_release_id,0) = Nvl(v_po_release_id,Nvl(pll.po_release_id,0))

Line 438: FROM wms_lpn_contents

434: -- Bug 3444226 The Join with po_headers is unnecessary
435: -- po_headers ph,
436: rcv_shipment_lines rsl,
437: (SELECT DISTINCT source_line_id
438: FROM wms_lpn_contents
439: WHERE parent_lpn_id = v_lpn_id) wlc
440: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
441: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)
442: AND Nvl(pll.po_release_id,0) = Nvl(v_po_release_id,Nvl(pll.po_release_id,0))

Line 516: FROM wms_lpn_contents

512: -- Bug 3444226 The Join with po_headers is unnecessary
513: -- po_headers ph,
514: rcv_shipment_lines rsl,
515: (SELECT DISTINCT source_line_id
516: FROM wms_lpn_contents
517: WHERE parent_lpn_id = v_lpn_id) wlc
518: -- Bug 3444226 The condition with po_headers is unnecessary
519: -- WHERE ph.po_header_id = header_id
520: WHERE pll.po_header_id = header_id

Line 586: FROM wms_lpn_contents

582: -- Bug 3444226 The Join with po_headers is unnecessary
583: -- po_headers ph,
584: rcv_shipment_lines rsl,
585: (SELECT DISTINCT source_line_id
586: FROM wms_lpn_contents
587: WHERE parent_lpn_id = v_lpn_id) wlc
588: -- Bug 3444226 The Join with po_headers is unnecessary
589: -- WHERE ph.po_header_id = header_id
590: WHERE pll.po_header_id = header_id