DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MTL_LOT_NUMBERS

Line 1741: FROM MTL_LOT_NUMBERS MLN

1737: END IF;
1738:
1739: SELECT mln.*
1740: INTO p_lot
1741: FROM MTL_LOT_NUMBERS MLN
1742: WHERE MLN.INVENTORY_ITEM_ID = p_item.inventory_item_id
1743: AND MLN.ORGANIZATION_ID = p_org.organization_id
1744: AND MLN.LOT_NUMBER = p_lot.lot_number
1745: AND MLN.LOT_NUMBER IN (SELECT LOT_NUMBER

Line 3022: FROM MTL_LOT_NUMBERS MLN

3018:
3019:
3020: SELECT mln.*
3021: INTO p_lot
3022: FROM MTL_LOT_NUMBERS MLN
3023: WHERE MLN.INVENTORY_ITEM_ID = p_item.inventory_item_id
3024: AND MLN.ORGANIZATION_ID = p_org.organization_id
3025: AND MLN.LOT_NUMBER = p_lot.lot_number;
3026: