DBA Data[Home] [Help]

APPS.MTL_CC_TRANSACT_PKG dependencies on MTL_LOT_NUMBERS

Line 436: FROM MTL_LOT_NUMBERS

432: -- for this Lot Number if none was passed in
433: IF (LotExpDate IS NULL) THEN
434: SELECT EXPIRATION_DATE
435: INTO l_lot_exp_date
436: FROM MTL_LOT_NUMBERS
437: WHERE INVENTORY_ITEM_ID = item_id
438: AND ORGANIZATION_ID = org_id
439: AND LOT_NUMBER = LotNum;
440: ELSE