APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_SYSTEM_ITEMS

Line 1386: FROM mtl_system_items

1382: l_org := p_to_organization_id;
1383:
1384: SELECT restrict_locators_code
1385: INTO l_restrict_locators_code
1386: FROM mtl_system_items
1387: WHERE inventory_item_id = p_inventory_item_id
1388: AND organization_id = l_org;
1389: ELSE
1390: l_org := p_organization_id;

Line 1785: FROM mtl_system_items

1781: l_org := p_to_organization_id;
1782:
1783: SELECT restrict_subinventories_code
1784: INTO l_restrict_subinventories_code
1785: FROM mtl_system_items
1786: WHERE organization_id = l_org
1787: AND inventory_item_id = p_inventory_item_id;
1788: ELSE
1789: l_org := p_organization_id;

Line 1798: FROM mtl_system_items

1794: l_from_sub_asset_inventory := p_from_sub_asset_inventory;
1795:
1796: SELECT inventory_asset_flag
1797: INTO l_inventory_asset_flag
1798: FROM mtl_system_items
1799: WHERE inventory_item_id = p_inventory_item_id
1800: AND organization_id = l_org;
1801:
1802: fnd_profile.get('INV:EXPENSE_TO_ASSET_TRANSFER', l_expense_to_asset);

Line 3032: FROM mtl_system_items a

3028: SELECT 1
3029: INTO l_invalid_count
3030: FROM dual
3031: WHERE EXISTS (SELECT a.inventory_item_id
3032: FROM mtl_system_items a
3033: , mtl_system_items b
3034: WHERE a.inventory_item_id = b.inventory_item_id
3035: AND a.organization_id = p_orgid
3036: AND b.organization_id = p_to_organization_id

Line 3033: , mtl_system_items b

3029: INTO l_invalid_count
3030: FROM dual
3031: WHERE EXISTS (SELECT a.inventory_item_id
3032: FROM mtl_system_items a
3033: , mtl_system_items b
3034: WHERE a.inventory_item_id = b.inventory_item_id
3035: AND a.organization_id = p_orgid
3036: AND b.organization_id = p_to_organization_id
3037: AND a.inventory_item_id = l_item_id

Line 3062: FROM mtl_system_items

3058: -- b. The lot/serial/revision control code combinations are perfect
3059: -- We should check for scenario (a) and throw error.
3060: SELECT COUNT(*)
3061: INTO l_count
3062: FROM mtl_system_items
3063: WHERE organization_id = p_to_organization_id
3064: AND inventory_item_id = l_item_id;
3065:
3066: IF l_count = 1 THEN

Line 3100: FROM mtl_system_items

3096: l_count := 0;
3097:
3098: SELECT COUNT(*)
3099: INTO l_count
3100: FROM mtl_system_items
3101: WHERE organization_id = p_to_organization_id
3102: AND inventory_item_id = l_item_id;
3103:
3104: IF l_count = 1 THEN

Line 3246: FROM mtl_system_items

3242: SELECT restrict_subinventories_code
3243: , inventory_asset_flag
3244: INTO l_restrict_subinventories_code
3245: , l_inventory_asset_flag
3246: FROM mtl_system_items
3247: WHERE inventory_item_id = l_item_id
3248: AND organization_id = p_orgid;
3249:
3250: fnd_profile.get('INV:EXPENSE_TO_ASSET_TRANSFER', l_expense_to_asset);

Line 3387: FROM mtl_system_items

3383: l_lpn_content := 1;
3384:
3385: SELECT restrict_locators_code
3386: INTO l_restrict_locators_code
3387: FROM mtl_system_items
3388: WHERE inventory_item_id = l_item_id
3389: AND organization_id = p_orgid;
3390:
3391: IF l_restrict_locators_code = 1 THEN

Line 4441: FROM mtl_system_items

4437: l_org := p_to_organization_id;
4438:
4439: SELECT restrict_locators_code
4440: INTO l_restrict_locators_code
4441: FROM mtl_system_items
4442: WHERE inventory_item_id = p_inventory_item_id
4443: AND organization_id = l_org;
4444: ELSE
4445: l_org := p_organization_id;

Line 4501: FROM mtl_system_items

4497: l_org := p_to_organization_id;
4498:
4499: SELECT restrict_locators_code
4500: INTO l_restrict_locators_code
4501: FROM mtl_system_items
4502: WHERE inventory_item_id = p_inventory_item_id
4503: AND organization_id = l_org;
4504: ELSE
4505: l_org := p_organization_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