APPS.INV_MINMAX_PVT dependencies on MTL_ITEM_LOCATIONS

Line 1488: EXISTS (SELECT 1 FROM mtl_item_locations mil

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

Line 1534: EXISTS (SELECT 1 FROM mtl_item_locations mil

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

Line 1671: EXISTS (SELECT 1 FROM mtl_item_locations mil

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

Line 1916: EXISTS (SELECT 1 FROM mtl_item_locations mil

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

Line 2048: EXISTS (SELECT 1 FROM mtl_item_locations mil

2044: WHERE s.organization_id = p_org_id
2045: AND s.secondary_inventory_name = mtr.subinventory_code
2046: AND s.availability_type = DECODE(p_include_nonnet,1,s.availability_type,1)))
2047: AND (mtr.locator_id IS NULL OR
2048: EXISTS (SELECT 1 FROM mtl_item_locations mil
2049: WHERE mil.organization_id = p_org_id
2050: AND mil.inventory_location_id = mtr.locator_id
2051: AND mil.subinventory_code = NVL(mtr.subinventory_code, mil.subinventory_code)
2052: AND mil.availability_type = DECODE(p_include_nonnet,1,mil.availability_type,1)))

Line 2192: EXISTS (SELECT 1 FROM mtl_item_locations mil

2188: AND mtrl.date_required <= p_d_cutoff + 0.99999 /* bug no 6009682 */
2189: /* nsinghi MIN-MAX INVCONV start */
2190: AND (mtrl.from_locator_id IS NULL OR
2191: p_level = 2 OR
2192: EXISTS (SELECT 1 FROM mtl_item_locations mil
2193: WHERE mil.organization_id = p_org_id
2194: AND mil.inventory_location_id = mtrl.from_locator_id
2195: AND mil.subinventory_code = NVL(mtrl.from_subinventory_code, mil.subinventory_code)
2196: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1)))