DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

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

469: AWOS.workorder_id,
470: asml.inventory_item_id,
471: ASML.organization_id,
472: ASML.scheduled_material_id
473: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
474: WHERE AWOS.visit_task_id = ASML.visit_task_id
475: and ASML.inventory_item_id = MSIK.inventory_item_id
476: and ASML.organization_id = MSIK.organization_id
477: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID