APPS.INV_MINMAX_PVT dependencies on MTL_LOT_NUMBERS

Line 1495: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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

Line 1541: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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

Line 1678: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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

Line 1923: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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

Line 2054: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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)))
2053: AND (mtr.lot_number IS NULL OR
2054: EXISTS (SELECT 1 FROM mtl_lot_numbers mln
2055: WHERE mln.organization_id = p_org_id
2056: AND mln.lot_number = mtr.lot_number
2057: AND mln.inventory_item_id = p_item_id
2058: AND mln.availability_type = DECODE(p_include_nonnet,1,mln.availability_type,1)));

Line 2199: EXISTS (SELECT 1 FROM mtl_lot_numbers mln

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)))
2197: AND (mtrl.lot_number IS NULL OR
2198: p_level = 2 OR
2199: EXISTS (SELECT 1 FROM mtl_lot_numbers mln
2200: WHERE mln.organization_id = p_org_id
2201: AND mln.lot_number = mtrl.lot_number
2202: AND mln.inventory_item_id = p_item_id
2203: AND mln.availability_type = decode(p_include_nonnet,1,mln.availability_type,1)));