175: AND (CLN_INVENTORY_REPORT_V.revision IS NULL OR moqd.revision IS NULL OR moqd.revision = CLN_INVENTORY_REPORT_V.revision)
176: )
177: AND ( (p_lot_number IS NULL AND CLN_INVENTORY_REPORT_V.LOT_CONTROL_CODE = 1) OR
178: EXISTS (
179: SELECT 'X' FROM MTL_LOT_NUMBERS MLN
180: WHERE CLN_INVENTORY_REPORT_V.inventory_item_id = mln.inventory_item_id(+)
181: AND CLN_INVENTORY_REPORT_V.organization_id = mln.organization_id(+)
182: AND mln.lot_number = NVL(p_lot_number,mln.lot_number)
183: )