DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 741: FROM MTL_SYSTEM_ITEMS_VL

737: -- Get Primary Uom Code
738: CURSOR Primary_Uom_cur (c_item_id IN NUMBER,
739: c_org_id IN NUMBER) IS
740: SELECT primary_uom_code
741: FROM MTL_SYSTEM_ITEMS_VL
742: WHERE inventory_item_id = c_item_id
743: AND organization_id = c_org_id;
744: --Get operation sequnece
745: CURSOR Get_Operation_Seq_cur(c_operation_id IN NUMBER)

Line 2972: MTL_SYSTEM_ITEMS_VL MSIV,

2968: FROM
2969: AHL_WORKORDERS AWOS,
2970: AHL_SCHEDULE_MATERIALS ASML,
2971: wip_requirement_operations wipr,
2972: MTL_SYSTEM_ITEMS_VL MSIV,
2973: AHL_VISITS_VL AVST,
2974: AHL_WORKORDER_OPERATIONS AWOP,
2975: -- added for FP bug# 6802777
2976: WIP_OPERATIONS WOP