APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_SYSTEM_ITEMS

Line 1049: FROM mtl_system_items

1045: l_org := p_to_organization_id;
1046:
1047: SELECT restrict_locators_code
1048: INTO l_restrict_locators_code
1049: FROM mtl_system_items
1050: WHERE inventory_item_id = p_inventory_item_id
1051: AND organization_id = l_org;
1052: ELSE
1053: l_org := p_organization_id;

Line 1410: FROM mtl_system_items

1406: l_org := p_to_organization_id;
1407:
1408: SELECT restrict_subinventories_code
1409: INTO l_restrict_subinventories_code
1410: FROM mtl_system_items
1411: WHERE organization_id = l_org
1412: AND inventory_item_id = p_inventory_item_id;
1413: ELSE
1414: l_org := p_organization_id;

Line 1423: FROM mtl_system_items

1419: l_from_sub_asset_inventory := p_from_sub_asset_inventory;
1420:
1421: SELECT inventory_asset_flag
1422: INTO l_inventory_asset_flag
1423: FROM mtl_system_items
1424: WHERE inventory_item_id = p_inventory_item_id
1425: AND organization_id = l_org;
1426:
1427: fnd_profile.get('INV:EXPENSE_TO_ASSET_TRANSFER', l_expense_to_asset);

Line 2655: FROM mtl_system_items a

2651: SELECT 1
2652: INTO l_invalid_count
2653: FROM dual
2654: WHERE EXISTS (SELECT a.inventory_item_id
2655: FROM mtl_system_items a
2656: , mtl_system_items b
2657: WHERE a.inventory_item_id = b.inventory_item_id
2658: AND a.organization_id = p_orgid
2659: AND b.organization_id = p_to_organization_id

Line 2656: , mtl_system_items b

2652: INTO l_invalid_count
2653: FROM dual
2654: WHERE EXISTS (SELECT a.inventory_item_id
2655: FROM mtl_system_items a
2656: , mtl_system_items b
2657: WHERE a.inventory_item_id = b.inventory_item_id
2658: AND a.organization_id = p_orgid
2659: AND b.organization_id = p_to_organization_id
2660: AND a.inventory_item_id = l_item_id

Line 2685: FROM mtl_system_items

2681: -- b. The lot/serial/revision control code combinations are perfect
2682: -- We should check for scenario (a) and throw error.
2683: SELECT COUNT(*)
2684: INTO l_count
2685: FROM mtl_system_items
2686: WHERE organization_id = p_to_organization_id
2687: AND inventory_item_id = l_item_id;
2688:
2689: IF l_count = 1 THEN

Line 2723: FROM mtl_system_items

2719: l_count := 0;
2720:
2721: SELECT COUNT(*)
2722: INTO l_count
2723: FROM mtl_system_items
2724: WHERE organization_id = p_to_organization_id
2725: AND inventory_item_id = l_item_id;
2726:
2727: IF l_count = 1 THEN

Line 2869: FROM mtl_system_items

2865: SELECT restrict_subinventories_code
2866: , inventory_asset_flag
2867: INTO l_restrict_subinventories_code
2868: , l_inventory_asset_flag
2869: FROM mtl_system_items
2870: WHERE inventory_item_id = l_item_id
2871: AND organization_id = p_orgid;
2872:
2873: fnd_profile.get('INV:EXPENSE_TO_ASSET_TRANSFER', l_expense_to_asset);

Line 2992: FROM mtl_system_items

2988: l_lpn_content := 1;
2989:
2990: SELECT restrict_locators_code
2991: INTO l_restrict_locators_code
2992: FROM mtl_system_items
2993: WHERE inventory_item_id = l_item_id
2994: AND organization_id = p_orgid;
2995:
2996: IF l_restrict_locators_code = 1 THEN

Line 4015: FROM mtl_system_items

4011: l_org := p_to_organization_id;
4012:
4013: SELECT restrict_locators_code
4014: INTO l_restrict_locators_code
4015: FROM mtl_system_items
4016: WHERE inventory_item_id = p_inventory_item_id
4017: AND organization_id = l_org;
4018: ELSE
4019: l_org := p_organization_id;

Line 4062: FROM mtl_system_items

4058: l_org := p_to_organization_id;
4059:
4060: SELECT restrict_locators_code
4061: INTO l_restrict_locators_code
4062: FROM mtl_system_items
4063: WHERE inventory_item_id = p_inventory_item_id
4064: AND organization_id = l_org;
4065: ELSE
4066: l_org := p_organization_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