DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 452: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

448: AWOS.workorder_id,
449: asml.inventory_item_id,
450: ASML.organization_id,
451: ASML.scheduled_material_id
452: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
453: WHERE AWOS.visit_task_id = ASML.visit_task_id
454: and ASML.inventory_item_id = MSIK.inventory_item_id
455: and ASML.organization_id = MSIK.organization_id
456: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID