APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on WMS_LPN_CONTENTS

Line 3005: FROM wms_lpn_contents

3001: l_invalid_count NUMBER := 0;
3002:
3003: CURSOR l_item_cursor IS
3004: SELECT DISTINCT inventory_item_id
3005: FROM wms_lpn_contents
3006: WHERE parent_lpn_id IN (SELECT lpn_id
3007: FROM wms_license_plate_numbers
3008: WHERE outermost_lpn_id = p_lpn_id)
3009: AND inventory_item_id IS NOT NULL;

Line 3216: FROM wms_lpn_contents

3212: l_lpn_content NUMBER;
3213:
3214: CURSOR l_item_cursor IS
3215: SELECT DISTINCT inventory_item_id
3216: FROM wms_lpn_contents
3217: WHERE parent_lpn_id IN (SELECT lpn_id
3218: FROM wms_license_plate_numbers
3219: WHERE outermost_lpn_id = p_lpn_id)
3220: AND inventory_item_id IS NOT NULL;

Line 3225: FROM wms_lpn_contents

3221: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3222: BEGIN
3223: /*
3224: SELECT DISTINCT content_type INTO l_content_type
3225: FROM wms_lpn_contents
3226: WHERE outermost_lpn_id = p_lpn_id;
3227:
3228: IF l_content_type NOT IN (1) THEN
3229: RETURN 'Y';

Line 3369: FROM wms_lpn_contents

3365: l_lpn_content NUMBER;
3366:
3367: CURSOR l_item_cursor IS
3368: SELECT DISTINCT inventory_item_id
3369: FROM wms_lpn_contents
3370: WHERE parent_lpn_id IN (SELECT lpn_id
3371: FROM wms_license_plate_numbers
3372: WHERE outermost_lpn_id = p_lpn_id)
3373: AND inventory_item_id IS NOT NULL;

Line 3525: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

3521: , wlc.lot_number
3522: , wlc.inventory_item_id
3523: , wlpn.subinventory_code
3524: , wlpn.locator_id
3525: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
3526: WHERE wlc.organization_id = p_orgid
3527: AND wlc.parent_lpn_id = wlpn.lpn_id
3528: AND wlc.organization_id = wlpn.organization_id
3529: AND wlc.parent_lpn_id IN (SELECT lpn_id

Line 4865: FROM wms_lpn_contents wlc, mtl_system_items msi

4861:
4862: CURSOR l_item_cursor IS
4863: SELECT DISTINCT wlc.inventory_item_id
4864: , msi.restrict_subinventories_code
4865: FROM wms_lpn_contents wlc, mtl_system_items msi
4866: WHERE wlc.parent_lpn_id IN(SELECT lpn_id
4867: FROM wms_license_plate_numbers
4868: WHERE outermost_lpn_id = p_lpn_id)
4869: AND wlc.inventory_item_id IS NOT NULL

Line 5044: FROM wms_lpn_contents wlc, mtl_system_items msi

5040: l_transaction_type NUMBER;
5041: l_count NUMBER;
5042: CURSOR l_item_cursor IS
5043: SELECT DISTINCT wlc.inventory_item_id, msi.restrict_locators_code
5044: FROM wms_lpn_contents wlc, mtl_system_items msi
5045: WHERE wlc.parent_lpn_id IN (SELECT lpn_id
5046: FROM wms_license_plate_numbers
5047: WHERE outermost_lpn_id = p_lpn_id)
5048: AND wlc.inventory_item_id IS NOT NULL