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 3720: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn

3716: , wlpn.locator_id
3717: , wlc.lot_number
3718: , wlc.inventory_item_id
3719: , msn.serial_number
3720: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn
3721: WHERE wlpn.lpn_id = wlc.parent_lpn_id
3722: AND msn.lpn_id(+) = wlc.parent_lpn_id
3723: AND msn.inventory_item_id(+) = wlc.inventory_item_id
3724: AND msn.current_organization_id(+) = wlc.organization_id

Line 8263: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,

8259: -- Cursor to get the item qty in the LPN corresponding to the given delivery_id
8260: -- and the inventory item,revision
8261: CURSOR lpn_item_qty(p_delivery_id NUMBER, p_item_id NUMBER, p_revision VARCHAR2, p_lot_number VARCHAR2) IS
8262: SELECT SUM(wlc.quantity)
8263: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,
8264: wms_shipping_transaction_temp wstt
8265: WHERE wlc.parent_lpn_id = lpn.lpn_id
8266: and wstt.delivery_id = p_delivery_id
8267: and lpn.outermost_lpn_id = wstt.outermost_lpn_id

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

8296: --Query to get the total no. of distinct items in the lpn to be shipped
8297:
8298: SELECT COUNT(COUNT(*))
8299: INTO l_lpn_item_count
8300: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc, wms_shipping_transaction_temp wstt
8301: WHERE wstt.delivery_id = p_delivery_id
8302: AND wstt.outermost_lpn_id = wlpn.outermost_lpn_id
8303: AND wlpn.lpn_id = wlc.parent_lpn_id
8304: GROUP BY wlc.inventory_item_id, wlc.revision;

Line 9361: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE

9357: TYPE l_lpn_content_cur_rec_typ IS RECORD(
9358: lpn_id wms_license_plate_numbers.lpn_id%TYPE
9359: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
9360: , locator_id wms_license_plate_numbers.locator_id%TYPE
9361: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
9362: , revision wms_lpn_contents.revision%TYPE
9363: , lot_number wms_lpn_contents.lot_number%TYPE
9364: , quantity wms_lpn_contents.quantity%TYPE
9365: , secondary_quantity wms_lpn_contents.secondary_quantity%TYPE

Line 9362: , revision wms_lpn_contents.revision%TYPE

9358: lpn_id wms_license_plate_numbers.lpn_id%TYPE
9359: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
9360: , locator_id wms_license_plate_numbers.locator_id%TYPE
9361: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
9362: , revision wms_lpn_contents.revision%TYPE
9363: , lot_number wms_lpn_contents.lot_number%TYPE
9364: , quantity wms_lpn_contents.quantity%TYPE
9365: , secondary_quantity wms_lpn_contents.secondary_quantity%TYPE
9366: , revision_control VARCHAR2(5)

Line 9363: , lot_number wms_lpn_contents.lot_number%TYPE

9359: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
9360: , locator_id wms_license_plate_numbers.locator_id%TYPE
9361: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
9362: , revision wms_lpn_contents.revision%TYPE
9363: , lot_number wms_lpn_contents.lot_number%TYPE
9364: , quantity wms_lpn_contents.quantity%TYPE
9365: , secondary_quantity wms_lpn_contents.secondary_quantity%TYPE
9366: , revision_control VARCHAR2(5)
9367: , lot_control VARCHAR2(5)

Line 9364: , quantity wms_lpn_contents.quantity%TYPE

9360: , locator_id wms_license_plate_numbers.locator_id%TYPE
9361: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
9362: , revision wms_lpn_contents.revision%TYPE
9363: , lot_number wms_lpn_contents.lot_number%TYPE
9364: , quantity wms_lpn_contents.quantity%TYPE
9365: , secondary_quantity wms_lpn_contents.secondary_quantity%TYPE
9366: , revision_control VARCHAR2(5)
9367: , lot_control VARCHAR2(5)
9368: , serial_control VARCHAR2(5)

Line 9365: , secondary_quantity wms_lpn_contents.secondary_quantity%TYPE

9361: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
9362: , revision wms_lpn_contents.revision%TYPE
9363: , lot_number wms_lpn_contents.lot_number%TYPE
9364: , quantity wms_lpn_contents.quantity%TYPE
9365: , secondary_quantity wms_lpn_contents.secondary_quantity%TYPE
9366: , revision_control VARCHAR2(5)
9367: , lot_control VARCHAR2(5)
9368: , serial_control VARCHAR2(5)
9369: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE

Line 9506: ' FROM wms_lpn_contents wlc ' ||

9502: ' , msi.serial_number_control_code serial_control_code ' ||
9503: ' , msi.reservable_type ' ||
9504: ' , NULL ' ||
9505: ' , msi.ont_pricing_qty_source ' ||
9506: ' FROM wms_lpn_contents wlc ' ||
9507: ' , wms_license_plate_numbers wlpn ' ||
9508: ' , mtl_system_items_b msi ' ||
9509: ' WHERE msi.inventory_item_id = wlc.inventory_item_id ' ||
9510: ' AND wlpn.lpn_id = wlc.parent_lpn_id ' ||

Line 9545: ' FROM wms_lpn_contents wlc ' ||

9541: ' , msi.serial_number_control_code serial_control_code ' ||
9542: ' , msi.reservable_type ' ||
9543: ' , msn.end_item_unit_number ' ||
9544: ' , msi.ont_pricing_qty_source ' ||
9545: ' FROM wms_lpn_contents wlc ' ||
9546: ' , wms_license_plate_numbers wlpn ' ||
9547: ' , mtl_system_items_b msi ' ||
9548: ' , (SELECT lpn_id ' ||
9549: ' , revision ' ||

Line 13832: , wms_lpn_contents wlc

13828: WHERE wlpn.organization_id = p_org_id
13829: AND wlpn.lpn_id = p_lpn_id
13830: AND EXISTS ( SELECT 'x'
13831: FROM wms_license_plate_numbers wlpn2
13832: , wms_lpn_contents wlc
13833: , mtl_system_items msi
13834: WHERE wlpn2.outermost_lpn_id = wlpn.outermost_lpn_id
13835: AND wlc.parent_lpn_id = wlpn2.lpn_id
13836: AND msi.inventory_item_id = wlc.inventory_item_id