DBA Data[Home] [Help]

APPS.CLN_SYNC_INVENTORY_PKG dependencies on MTL_LOT_NUMBERS

Line 179: SELECT 'X' FROM MTL_LOT_NUMBERS MLN

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: )