DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MTL_LOT_NUMBERS

Line 1866: FROM MTL_LOT_NUMBERS MLN

1862: END IF;
1863:
1864: SELECT mln.*
1865: INTO p_lot
1866: FROM MTL_LOT_NUMBERS MLN
1867: WHERE MLN.INVENTORY_ITEM_ID = p_item.inventory_item_id
1868: AND MLN.ORGANIZATION_ID = p_org.organization_id
1869: AND MLN.LOT_NUMBER = p_lot.lot_number
1870: AND MLN.LOT_NUMBER IN (SELECT LOT_NUMBER

Line 3156: FROM MTL_LOT_NUMBERS MLN

3152:
3153:
3154: SELECT mln.*
3155: INTO p_lot
3156: FROM MTL_LOT_NUMBERS MLN
3157: WHERE MLN.INVENTORY_ITEM_ID = p_item.inventory_item_id
3158: AND MLN.ORGANIZATION_ID = p_org.organization_id
3159: AND MLN.LOT_NUMBER = p_lot.lot_number;
3160: