DBA Data[Home] [Help]

APPS.AHL_VWP_PRICE_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 828: wip_requirement_operations wiro,

824: sum(nvl(wiro.REQUIRED_QUANTITY,0)) quantity,
825: mtl.primary_uom_code uom_code
826: FROM ahl_workorders awo,
827: ahl_schedule_materials asm,
828: wip_requirement_operations wiro,
829: mtl_system_items_b mtl
830: WHERE awo.visit_task_id = c_visit_task_id
831: AND awo.visit_task_id = asm.visit_task_id
832: AND asm.inventory_item_id = mtl.inventory_item_id