DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_ITEM_LOCATIONS

Line 742: mtl_item_locations LOC

738: l_uom
739: FROM mtl_system_items_b ITEMS,
740: ahl_schedule_materials ASM,
741: ahl_visits_b VST,
742: mtl_item_locations LOC
743: WHERE ITEMS.inventory_item_id = ASM.inventory_item_id
744: AND ITEMS.organization_id = ASM.organization_id
745: AND ASM.visit_id = VST.visit_id
746: AND VST.inv_locator_id = LOC.inventory_location_id (+)

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

Line 5184: FROM MTL_ITEM_LOCATIONS

5180: -- Locator validation
5181: CURSOR LOCATOR_VALID_CUR (p_org_id NUMBER, p_loc_id NUMBER)
5182: IS
5183: SELECT 1
5184: FROM MTL_ITEM_LOCATIONS
5185: WHERE INVENTORY_LOCATION_ID = p_loc_id
5186: AND ORGANIZATION_ID = p_org_id;
5187: -- Reservation validation
5188: CURSOR RESERVATION_VALID_CUR (p_org_id NUMBER, p_item NUMBER, p_serial_num VARCHAR2)