APPS.INV_MWB_CG_TRANSFER dependencies on MTL_LOT_NUMBERS_ALL_V
Line 148: FROM MTL_LOT_NUMBERS_ALL_V
144: IF L_EXP_DATE IS NULL THEN
145:
146: SELECT EXPIRATION_DATE
147: INTO L_EXP_DATE 148: FROM MTL_LOT_NUMBERS_ALL_V 149: WHERE ORGANIZATION_ID = P_ORG_ID
150: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
151: AND LOT_NUMBER = P_LOT_NUMBER;
152: