APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on WMS_LPN_CONTENTS

Line 2628: FROM wms_lpn_contents

2624: l_invalid_count NUMBER := 0;
2625:
2626: CURSOR l_item_cursor IS
2627: SELECT DISTINCT inventory_item_id
2628: FROM wms_lpn_contents
2629: WHERE parent_lpn_id IN (SELECT lpn_id
2630: FROM wms_license_plate_numbers
2631: WHERE outermost_lpn_id = p_lpn_id)
2632: AND inventory_item_id IS NOT NULL;

Line 2839: FROM wms_lpn_contents

2835: l_lpn_content NUMBER;
2836:
2837: CURSOR l_item_cursor IS
2838: SELECT DISTINCT inventory_item_id
2839: FROM wms_lpn_contents
2840: WHERE parent_lpn_id IN (SELECT lpn_id
2841: FROM wms_license_plate_numbers
2842: WHERE outermost_lpn_id = p_lpn_id)
2843: AND inventory_item_id IS NOT NULL;

Line 2848: FROM wms_lpn_contents

2844: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2845: BEGIN
2846: /*
2847: SELECT DISTINCT content_type INTO l_content_type
2848: FROM wms_lpn_contents
2849: WHERE outermost_lpn_id = p_lpn_id;
2850:
2851: IF l_content_type NOT IN (1) THEN
2852: RETURN 'Y';

Line 2974: FROM wms_lpn_contents

2970: l_lpn_content NUMBER;
2971:
2972: CURSOR l_item_cursor IS
2973: SELECT DISTINCT inventory_item_id
2974: FROM wms_lpn_contents
2975: WHERE parent_lpn_id IN (SELECT lpn_id
2976: FROM wms_license_plate_numbers
2977: WHERE outermost_lpn_id = p_lpn_id)
2978: AND inventory_item_id IS NOT NULL;

Line 3130: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

3126: , wlc.lot_number
3127: , wlc.inventory_item_id
3128: , wlpn.subinventory_code
3129: , wlpn.locator_id
3130: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
3131: WHERE wlc.organization_id = p_orgid
3132: AND wlc.parent_lpn_id = wlpn.lpn_id
3133: AND wlc.organization_id = wlpn.organization_id
3134: AND wlc.parent_lpn_id IN (SELECT lpn_id

Line 4410: FROM wms_lpn_contents wlc, mtl_system_items msi

4406:
4407: CURSOR l_item_cursor IS
4408: SELECT DISTINCT wlc.inventory_item_id
4409: , msi.restrict_subinventories_code
4410: FROM wms_lpn_contents wlc, mtl_system_items msi
4411: WHERE wlc.parent_lpn_id IN(SELECT lpn_id
4412: FROM wms_license_plate_numbers
4413: WHERE outermost_lpn_id = p_lpn_id)
4414: AND wlc.inventory_item_id IS NOT NULL

Line 4587: FROM wms_lpn_contents wlc, mtl_system_items msi

4583: l_transaction_type NUMBER;
4584: l_count NUMBER;
4585: CURSOR l_item_cursor IS
4586: SELECT DISTINCT wlc.inventory_item_id, msi.restrict_locators_code
4587: FROM wms_lpn_contents wlc, mtl_system_items msi
4588: WHERE wlc.parent_lpn_id IN (SELECT lpn_id
4589: FROM wms_license_plate_numbers
4590: WHERE outermost_lpn_id = p_lpn_id)
4591: AND wlc.inventory_item_id IS NOT NULL