APPS.INV_MINMAX_PVT dependencies on MTL_ITEM_LOCATIONS

Line 1485: EXISTS (SELECT 1 FROM mtl_item_locations mil

1481: 1)))
1482: /* nsinghi MIN-MAX INVCONV start */
1483: AND (locator_id IS NULL OR
1484: p_level = 2 OR
1485: EXISTS (SELECT 1 FROM mtl_item_locations mil
1486: WHERE mil.organization_id = p_org_id
1487: AND mil.inventory_location_id = locator_id
1488: AND mil.subinventory_code = NVL(subinventory, mil.subinventory_code)
1489: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1)))

Line 1531: EXISTS (SELECT 1 FROM mtl_item_locations mil

1527: 1)))
1528: /* nsinghi MIN-MAX INVCONV start */
1529: AND (locator_id IS NULL OR
1530: p_level = 2 OR
1531: EXISTS (SELECT 1 FROM mtl_item_locations mil
1532: WHERE mil.organization_id = p_org_id
1533: AND mil.inventory_location_id = locator_id
1534: AND mil.subinventory_code = NVL(subinventory_code, mil.subinventory_code)
1535: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1)))

Line 1668: EXISTS (SELECT 1 FROM mtl_item_locations mil

1664: 1)))
1665: /* nsinghi MIN-MAX INVCONV start */
1666: AND (locator_id IS NULL OR
1667: p_level = 2 OR
1668: EXISTS (SELECT 1 FROM mtl_item_locations mil
1669: WHERE mil.organization_id = p_org_id
1670: AND mil.inventory_location_id = locator_id
1671: AND mil.subinventory_code = NVL(subinventory_code, mil.subinventory_code)
1672: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1)))

Line 1913: EXISTS (SELECT 1 FROM mtl_item_locations mil

1909: 1)))
1910: /* nsinghi MIN-MAX INVCONV start */
1911: AND (md.locator_id IS NULL OR
1912: p_level = 2 OR
1913: EXISTS (SELECT 1 FROM mtl_item_locations mil
1914: WHERE mil.organization_id = p_org_id
1915: AND mil.inventory_location_id = md.locator_id
1916: AND mil.subinventory_code = NVL(md.subinventory_code, mil.subinventory_code)
1917: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1)))

Line 2038: EXISTS (SELECT 1 FROM mtl_item_locations mil

2034: WHERE s.organization_id = p_org_id
2035: AND s.secondary_inventory_name = mtr.subinventory_code
2036: AND s.availability_type = DECODE(p_include_nonnet,1,s.availability_type,1)))
2037: AND (mtr.locator_id IS NULL OR
2038: EXISTS (SELECT 1 FROM mtl_item_locations mil
2039: WHERE mil.organization_id = p_org_id
2040: AND mil.inventory_location_id = mtr.locator_id
2041: AND mil.subinventory_code = NVL(mtr.subinventory_code, mil.subinventory_code)
2042: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1)))

Line 2182: EXISTS (SELECT 1 FROM mtl_item_locations mil

2178: AND mtrl.date_required <= p_d_cutoff + 0.99999 /* bug no 6009682 */
2179: /* nsinghi MIN-MAX INVCONV start */
2180: AND (mtrl.from_locator_id IS NULL OR
2181: p_level = 2 OR
2182: EXISTS (SELECT 1 FROM mtl_item_locations mil
2183: WHERE mil.organization_id = p_org_id
2184: AND mil.inventory_location_id = mtrl.from_locator_id
2185: AND mil.subinventory_code = NVL(mtrl.from_subinventory_code, mil.subinventory_code)
2186: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1)))