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.INV_RCV_TXN_MATCH dependencies on WMS_LPN_CONTENTS

Line 81: FROM wms_lpn_contents

77: , rcv_shipment_headers rsh
78: , po_line_locations poll
79: , po_distributions pod
80: , (SELECT DISTINCT source_line_id
81: FROM wms_lpn_contents
82: WHERE parent_lpn_id = v_lpn_id) wlc
83: WHERE rsl.shipment_header_id = rsh.shipment_header_id
84: AND rsl.shipment_header_id = v_shipment_header_id
85: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 179: FROM wms_lpn_contents

175: , rcv_shipment_headers rsh
176: , po_line_locations poll
177: , po_distributions pod
178: , (SELECT DISTINCT source_line_id
179: FROM wms_lpn_contents
180: WHERE parent_lpn_id = v_lpn_id) wlc
181: WHERE rsl.shipment_header_id = rsh.shipment_header_id
182: AND rsl.shipment_header_id = v_shipment_header_id
183: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 273: FROM wms_lpn_contents

269: FROM rcv_shipment_lines rsl
270: , rcv_shipment_headers rsh
271: , po_line_locations poll
272: , (SELECT DISTINCT source_line_id
273: FROM wms_lpn_contents
274: WHERE parent_lpn_id = v_lpn_id) wlc
275: WHERE rsl.shipment_header_id = rsh.shipment_header_id
276: AND rsl.shipment_header_id = v_shipment_header_id
277: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 382: FROM wms_lpn_contents

378: FROM rcv_shipment_lines rsl
379: , rcv_shipment_headers rsh
380: , po_line_locations poll
381: , (SELECT DISTINCT source_line_id
382: FROM wms_lpn_contents
383: WHERE parent_lpn_id = v_lpn_id) wlc
384: WHERE rsl.shipment_header_id = rsh.shipment_header_id
385: AND rsl.shipment_header_id = v_shipment_header_id
386: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 490: FROM wms_lpn_contents

486: , rcv_shipment_headers rsh
487: , po_line_locations poll
488: , po_distributions pod
489: , (SELECT DISTINCT source_line_id
490: FROM wms_lpn_contents
491: WHERE parent_lpn_id = v_lpn_id) wlc
492: WHERE rsl.shipment_header_id = rsh.shipment_header_id
493: AND rsl.shipment_header_id = v_shipment_header_id
494: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 581: FROM wms_lpn_contents

577: , rcv_shipment_headers rsh
578: , po_line_locations poll
579: , po_distributions pod
580: , (SELECT DISTINCT source_line_id
581: FROM wms_lpn_contents
582: WHERE parent_lpn_id = v_lpn_id) wlc
583: WHERE rsl.shipment_header_id = rsh.shipment_header_id
584: AND rsl.shipment_header_id = v_shipment_header_id
585: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 668: FROM wms_lpn_contents

664: FROM rcv_shipment_lines rsl
665: , rcv_shipment_headers rsh
666: , po_line_locations poll
667: , (SELECT DISTINCT source_line_id
668: FROM wms_lpn_contents
669: WHERE parent_lpn_id = v_lpn_id) wlc
670: WHERE rsl.shipment_header_id = rsh.shipment_header_id
671: AND rsl.shipment_header_id = v_shipment_header_id
672: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 770: FROM wms_lpn_contents

766: FROM rcv_shipment_lines rsl
767: , rcv_shipment_headers rsh
768: , po_line_locations poll
769: , (SELECT DISTINCT source_line_id
770: FROM wms_lpn_contents
771: WHERE parent_lpn_id = v_lpn_id) wlc
772: WHERE rsl.shipment_header_id = rsh.shipment_header_id
773: AND rsl.shipment_header_id = v_shipment_header_id
774: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)