APPS.INV_MINMAX_PVT dependencies on MTL_LOT_NUMBERS

Line 1492: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

1488: AND mil.subinventory_code = NVL(subinventory, mil.subinventory_code)
1489: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1)))
1490: AND (lot_number IS NULL OR
1491: p_level = 2 OR
1492: EXISTS (SELECT 1 FROM mtl_lot_numbers mln
1493: WHERE mln.organization_id = p_org_id
1494: AND mln.lot_number = lot_number
1495: AND mln.inventory_item_id = p_item_id
1496: AND mln.availability_type = decode(p_include_nonnet,1,mln.availability_type,1)));

Line 1538: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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)))
1536: AND (lot_number IS NULL OR
1537: p_level = 2 OR
1538: EXISTS (SELECT 1 FROM mtl_lot_numbers mln
1539: WHERE mln.organization_id = p_org_id
1540: AND mln.lot_number = lot_number
1541: AND mln.inventory_item_id = p_item_id
1542: AND mln.availability_type = decode(p_include_nonnet,1,mln.availability_type,1)));

Line 1675: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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)))
1673: AND (lot_number IS NULL OR
1674: p_level = 2 OR
1675: EXISTS (SELECT 1 FROM mtl_lot_numbers mln
1676: WHERE mln.organization_id = p_org_id
1677: AND mln.lot_number = lot_number
1678: AND mln.inventory_item_id = p_item_id
1679: AND mln.availability_type = decode(p_include_nonnet,1,mln.availability_type,1)))

Line 1920: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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)))
1918: AND (md.lot_number IS NULL OR
1919: p_level = 2 OR
1920: EXISTS (SELECT 1 FROM mtl_lot_numbers mln
1921: WHERE mln.organization_id = p_org_id
1922: AND mln.lot_number = md.lot_number
1923: AND mln.inventory_item_id = p_item_id
1924: AND mln.availability_type = decode(p_include_nonnet,1,mln.availability_type,1)));

Line 2044: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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)))
2043: AND (mtr.lot_number IS NULL OR
2044: EXISTS (SELECT 1 FROM mtl_lot_numbers mln
2045: WHERE mln.organization_id = p_org_id
2046: AND mln.lot_number = mtr.lot_number
2047: AND mln.inventory_item_id = p_item_id
2048: AND mln.availability_type = decode(p_include_nonnet,1,mln.availability_type,1)));

Line 2189: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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)))
2187: AND (mtrl.lot_number IS NULL OR
2188: p_level = 2 OR
2189: EXISTS (SELECT 1 FROM mtl_lot_numbers mln
2190: WHERE mln.organization_id = p_org_id
2191: AND mln.lot_number = mtrl.lot_number
2192: AND mln.inventory_item_id = p_item_id
2193: AND mln.availability_type = decode(p_include_nonnet,1,mln.availability_type,1)));