DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1634: FROM wip_requirement_operations wip,

1630: -- Cursor to check whether WIP requirement exists for ASM record
1631: CURSOR Item_exists_in_wip_cur(c_scheduled_material_id IN NUMBER)
1632: IS
1633: SELECT 1
1634: FROM wip_requirement_operations wip,
1635: ahl_schedule_materials asm,
1636: ahl_workorders wo
1637: WHERE wo.visit_task_id = asm.visit_task_id
1638: AND wo.wip_entity_id = wip.wip_entity_id