APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 250: FROM mtl_item_sub_inventories mis

246: 2,--not be reservable
247: msub.reservable_type))
248:
249: AND EXISTS( SELECT NULL
250: FROM mtl_item_sub_inventories mis
251: WHERE mis.organization_id = NVL(p_organization_id, mis.organization_id)
252: AND mis.inventory_item_id = p_item_id
253: AND mis.secondary_inventory = msub.secondary_inventory_name)
254: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, msub.secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'

Line 362: FROM mtl_item_sub_inventories mis

358: ),
359: msub.reservable_type
360: )
361: AND EXISTS( SELECT NULL
362: FROM mtl_item_sub_inventories mis
363: WHERE mis.organization_id = NVL(p_organization_id, mis.organization_id)
364: AND mis.inventory_item_id = p_item_id
365: AND mis.secondary_inventory = msub.secondary_inventory_name)
366: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, msub.secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'

Line 1256: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1252: , a.description
1253: , a.asset_inventory
1254: , a.lpn_controlled_flag
1255: , a.enable_locator_alias
1256: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1257: WHERE a.organization_id = p_organization_id
1258: AND a.organization_id = b.organization_id
1259: AND b.inventory_item_id = p_inventory_item_id
1260: AND a.secondary_inventory_name = b.secondary_inventory

Line 1287: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1283: , a.description
1284: , a.asset_inventory
1285: , a.lpn_controlled_flag
1286: , a.enable_locator_alias
1287: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1288: WHERE a.organization_id = p_organization_id
1289: AND a.organization_id = b.organization_id
1290: AND a.secondary_inventory_name = b.secondary_inventory
1291: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1322: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1318: , a.description
1319: , a.asset_inventory
1320: , a.lpn_controlled_flag
1321: , a.enable_locator_alias
1322: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1323: WHERE a.organization_id = p_organization_id
1324: AND a.organization_id = b.organization_id
1325: AND a.secondary_inventory_name = b.secondary_inventory
1326: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1353: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1349: , a.description
1350: , a.asset_inventory
1351: , a.lpn_controlled_flag
1352: , a.enable_locator_alias
1353: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1354: WHERE a.organization_id = p_organization_id
1355: AND a.organization_id = b.organization_id
1356: AND a.secondary_inventory_name = b.secondary_inventory
1357: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1438: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1434: , a.description
1435: , a.asset_inventory
1436: , a.lpn_controlled_flag
1437: , a.enable_locator_alias
1438: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1439: WHERE a.organization_id = l_org
1440: AND a.organization_id = b.organization_id
1441: AND a.secondary_inventory_name = b.secondary_inventory
1442: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1471: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1467: , a.description
1468: , a.asset_inventory
1469: , a.lpn_controlled_flag
1470: , a.enable_locator_alias
1471: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1472: WHERE a.organization_id = l_org
1473: AND a.organization_id = b.organization_id
1474: -- and a.asset_inventory = 1
1475: AND b.inventory_item_id = p_inventory_item_id

Line 1488: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1484: , a.description
1485: , a.asset_inventory
1486: , a.lpn_controlled_flag
1487: , a.enable_locator_alias
1488: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1489: WHERE a.organization_id = l_org
1490: AND a.organization_id = b.organization_id
1491: AND a.asset_inventory = 2
1492: AND b.inventory_item_id = p_inventory_item_id

Line 1506: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1502: , a.description
1503: , a.asset_inventory
1504: , a.lpn_controlled_flag
1505: , a.enable_locator_alias
1506: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1507: WHERE a.organization_id = l_org
1508: AND a.organization_id = b.organization_id
1509: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1510: AND a.secondary_inventory_name = b.secondary_inventory

Line 2879: FROM mtl_item_sub_inventories

2875: IF (NVL(l_expense_to_asset, '2') = '1') THEN
2876: IF l_restrict_subinventories_code = 1 THEN
2877: SELECT COUNT(*)
2878: INTO l_count
2879: FROM mtl_item_sub_inventories
2880: WHERE inventory_item_id = l_item_id
2881: AND organization_id = p_orgid
2882: AND secondary_inventory = p_to_subinventory;
2883:

Line 2899: FROM mtl_item_sub_inventories

2895: IF l_inventory_asset_flag = 'Y' THEN
2896: IF p_from_sub_asset_inventory = 1 THEN
2897: SELECT COUNT(*)
2898: INTO l_count
2899: FROM mtl_item_sub_inventories
2900: WHERE inventory_item_id = l_item_id
2901: AND organization_id = p_orgid
2902: AND secondary_inventory = p_to_subinventory;
2903:

Line 2928: FROM mtl_item_sub_inventories

2924: END IF;
2925: ELSE
2926: SELECT COUNT(*)
2927: INTO l_count
2928: FROM mtl_item_sub_inventories
2929: WHERE inventory_item_id = l_item_id
2930: AND organization_id = p_orgid
2931: AND secondary_inventory = p_to_subinventory;
2932:

Line 4441: FROM mtl_item_sub_inventories

4437: -- check that the sub is allowed
4438: IF (l_restrict_sub = 1) THEN
4439: SELECT COUNT(*)
4440: INTO l_count
4441: FROM mtl_item_sub_inventories
4442: WHERE organization_id = p_organization_id
4443: AND inventory_item_id = l_item_id
4444: AND secondary_inventory = p_subinventory_code;
4445: