DBA Data[Home] [Help]

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: