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 83: FROM wms_lpn_contents

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

Line 183: FROM wms_lpn_contents

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

Line 310: FROM wms_lpn_contents

306: FROM rcv_shipment_lines rsl
307: , rcv_shipment_headers rsh
308: , po_line_locations poll
309: , (SELECT DISTINCT source_line_id
310: FROM wms_lpn_contents
311: WHERE parent_lpn_id = v_lpn_id) wlc
312: WHERE rsl.shipment_header_id = rsh.shipment_header_id
313: AND rsl.shipment_header_id = v_shipment_header_id
314: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 439: FROM wms_lpn_contents

435: FROM rcv_shipment_lines rsl
436: , rcv_shipment_headers rsh
437: , po_line_locations poll
438: , (SELECT DISTINCT source_line_id
439: FROM wms_lpn_contents
440: WHERE parent_lpn_id = v_lpn_id) wlc
441: WHERE rsl.shipment_header_id = rsh.shipment_header_id
442: AND rsl.shipment_header_id = v_shipment_header_id
443: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 563: FROM wms_lpn_contents

559: , rcv_shipment_headers rsh
560: , po_line_locations poll
561: , po_distributions pod
562: , (SELECT DISTINCT source_line_id
563: FROM wms_lpn_contents
564: WHERE parent_lpn_id = v_lpn_id) wlc
565: WHERE rsl.shipment_header_id = rsh.shipment_header_id
566: AND rsl.shipment_header_id = v_shipment_header_id
567: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 654: FROM wms_lpn_contents

650: , rcv_shipment_headers rsh
651: , po_line_locations poll
652: , po_distributions pod
653: , (SELECT DISTINCT source_line_id
654: FROM wms_lpn_contents
655: WHERE parent_lpn_id = v_lpn_id) wlc
656: WHERE rsl.shipment_header_id = rsh.shipment_header_id
657: AND rsl.shipment_header_id = v_shipment_header_id
658: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 741: FROM wms_lpn_contents

737: FROM rcv_shipment_lines rsl
738: , rcv_shipment_headers rsh
739: , po_line_locations poll
740: , (SELECT DISTINCT source_line_id
741: FROM wms_lpn_contents
742: WHERE parent_lpn_id = v_lpn_id) wlc
743: WHERE rsl.shipment_header_id = rsh.shipment_header_id
744: AND rsl.shipment_header_id = v_shipment_header_id
745: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 843: FROM wms_lpn_contents

839: FROM rcv_shipment_lines rsl
840: , rcv_shipment_headers rsh
841: , po_line_locations poll
842: , (SELECT DISTINCT source_line_id
843: FROM wms_lpn_contents
844: WHERE parent_lpn_id = v_lpn_id) wlc
845: WHERE rsl.shipment_header_id = rsh.shipment_header_id
846: AND rsl.shipment_header_id = v_shipment_header_id
847: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)