DBA Data[Home] [Help]

APPS.WIP_SO_RESERVATIONS dependencies on MTL_LOT_NUMBERS

Line 198: FROM MTL_LOT_NUMBERS

194: l_lotcount := 0 ;
195:
196: SELECT count(1)
197: INTO l_lotcount
198: FROM MTL_LOT_NUMBERS
199: WHERE INVENTORY_ITEM_ID = l_transaction_tbl(i).inventory_item_id
200: AND ORGANIZATION_ID = l_transaction_tbl(i).organization_id
201: AND LOT_NUMBER = l_transaction_tbl(i).lot_number;
202:

Line 293: FROM MTL_LOT_NUMBERS

289: l_lotcount := 0 ;
290:
291: SELECT count(1)
292: INTO l_lotcount
293: FROM MTL_LOT_NUMBERS
294: WHERE INVENTORY_ITEM_ID = l_transaction_tbl(i).inventory_item_id
295: AND ORGANIZATION_ID = l_transaction_tbl(i).organization_id
296: AND LOT_NUMBER = l_transaction_tbl(i).lot_number;
297:

Line 930: FROM MTL_LOT_NUMBERS

926: l_lotcount := 0 ;
927:
928: SELECT count(1)
929: INTO l_lotcount
930: FROM MTL_LOT_NUMBERS
931: WHERE INVENTORY_ITEM_ID = l_reservation_rec.inventory_item_id
932: AND ORGANIZATION_ID = l_reservation_rec.organization_id
933: AND LOT_NUMBER = l_reservation_rec.lot_number;
934: