DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2203: FROM AHL_VISITS_B AVB, MTL_ITEM_LOCATIONS_KFV MILK, AHL_SCHEDULE_MATERIALS ASM

2199: -- Get the demand sub inventory code and locator id value
2200: BEGIN
2201: SELECT MILK.SUBINVENTORY_CODE
2202: INTO L_DEMAND_SUBINV_CODE--, L_DEMAND_LOCATOR_ID
2203: FROM AHL_VISITS_B AVB, MTL_ITEM_LOCATIONS_KFV MILK, AHL_SCHEDULE_MATERIALS ASM
2204: WHERE AVB.INV_LOCATOR_ID = MILK.INVENTORY_LOCATION_ID(+)
2205: AND ASM.VISIT_ID = AVB.VISIT_ID
2206: and ASM.SCHEDULED_MATERIAL_ID = P_SCH_MTL_ID;
2207: EXCEPTION