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

Line 3529: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn

3525: , wlpn.locator_id
3526: , wlc.lot_number
3527: , wlc.inventory_item_id
3528: , msn.serial_number
3529: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn
3530: WHERE wlpn.lpn_id = wlc.parent_lpn_id
3531: AND msn.lpn_id(+) = wlc.parent_lpn_id
3532: AND msn.inventory_item_id(+) = wlc.inventory_item_id
3533: AND msn.current_organization_id(+) = wlc.organization_id

Line 7166: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,

7162: -- Cursor to get the item qty in the LPN corresponding to the given delivery_id
7163: -- and the inventory item,revision
7164: CURSOR lpn_item_qty(p_delivery_id NUMBER, p_item_id NUMBER, p_revision VARCHAR2, p_lot_number VARCHAR2) IS
7165: SELECT SUM(wlc.quantity)
7166: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,
7167: wms_shipping_transaction_temp wstt
7168: WHERE wlc.parent_lpn_id = lpn.lpn_id
7169: and wstt.delivery_id = p_delivery_id
7170: and lpn.outermost_lpn_id = wstt.outermost_lpn_id

Line 7203: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc, wms_shipping_transaction_temp wstt

7199: --Query to get the total no. of distinct items in the lpn to be shipped
7200:
7201: SELECT COUNT(COUNT(*))
7202: INTO l_lpn_item_count
7203: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc, wms_shipping_transaction_temp wstt
7204: WHERE wstt.delivery_id = p_delivery_id
7205: AND wstt.outermost_lpn_id = wlpn.outermost_lpn_id
7206: AND wlpn.lpn_id = wlc.parent_lpn_id
7207: GROUP BY wlc.inventory_item_id, wlc.revision;

Line 8244: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE

8240: TYPE l_lpn_content_cur_rec_typ IS RECORD(
8241: lpn_id wms_license_plate_numbers.lpn_id%TYPE
8242: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
8243: , locator_id wms_license_plate_numbers.locator_id%TYPE
8244: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
8245: , revision wms_lpn_contents.revision%TYPE
8246: , lot_number wms_lpn_contents.lot_number%TYPE
8247: , quantity wms_lpn_contents.quantity%TYPE
8248: , revision_control VARCHAR2(5)

Line 8245: , revision wms_lpn_contents.revision%TYPE

8241: lpn_id wms_license_plate_numbers.lpn_id%TYPE
8242: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
8243: , locator_id wms_license_plate_numbers.locator_id%TYPE
8244: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
8245: , revision wms_lpn_contents.revision%TYPE
8246: , lot_number wms_lpn_contents.lot_number%TYPE
8247: , quantity wms_lpn_contents.quantity%TYPE
8248: , revision_control VARCHAR2(5)
8249: , lot_control VARCHAR2(5)

Line 8246: , lot_number wms_lpn_contents.lot_number%TYPE

8242: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
8243: , locator_id wms_license_plate_numbers.locator_id%TYPE
8244: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
8245: , revision wms_lpn_contents.revision%TYPE
8246: , lot_number wms_lpn_contents.lot_number%TYPE
8247: , quantity wms_lpn_contents.quantity%TYPE
8248: , revision_control VARCHAR2(5)
8249: , lot_control VARCHAR2(5)
8250: , serial_control VARCHAR2(5)

Line 8247: , quantity wms_lpn_contents.quantity%TYPE

8243: , locator_id wms_license_plate_numbers.locator_id%TYPE
8244: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
8245: , revision wms_lpn_contents.revision%TYPE
8246: , lot_number wms_lpn_contents.lot_number%TYPE
8247: , quantity wms_lpn_contents.quantity%TYPE
8248: , revision_control VARCHAR2(5)
8249: , lot_control VARCHAR2(5)
8250: , serial_control VARCHAR2(5)
8251: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE

Line 8392: ' FROM wms_lpn_contents wlc ' ||

8388: l_sql_query := l_sql_query || ' , NULL ont_pricing_qty_source ';
8389: END IF;
8390:
8391: l_sql_query := l_sql_query ||
8392: ' FROM wms_lpn_contents wlc ' ||
8393: ' , wms_license_plate_numbers wlpn ' ||
8394: ' , mtl_system_items_b msi ' ||
8395: ' , (SELECT lpn_id ' ||
8396: ' , revision ' ||