APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_WORKORDERS

Line 1636: ahl_workorders wo

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
1639: AND asm.operation_sequence = wip.operation_seq_num
1640: AND asm.inventory_item_id = wip.inventory_item_id

Line 3593: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr

3589:
3590: CURSOR get_workorder_detls (c_task_id IN NUMBER)
3591: IS
3592: SELECT wip.scheduled_start_date, wo.workorder_id, opr.operation_sequence_num, opr.workorder_operation_id
3593: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr
3594: WHERE wo.visit_task_id = c_task_id
3595: AND wo.wip_entity_id = wip.wip_entity_id
3596: AND opr.workorder_id = wo.workorder_id;
3597:

Line 4054: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr

4050:
4051: CURSOR get_workorder_detls (c_task_id IN NUMBER)
4052: IS
4053: SELECT wip.scheduled_start_date, wo.workorder_id, opr.operation_sequence_num, opr.workorder_operation_id
4054: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr
4055: WHERE wo.visit_task_id = c_task_id
4056: AND wo.wip_entity_id = wip.wip_entity_id
4057: AND opr.workorder_id = wo.workorder_id;
4058:

Line 4386: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr

4382: -- Cursor to workorder details of the default stage task
4383: CURSOR get_workorder_detls (c_task_id IN NUMBER)
4384: IS
4385: SELECT wip.scheduled_start_date, wo.workorder_id, opr.operation_sequence_num, opr.workorder_operation_id, wo.visit_id
4386: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr
4387: WHERE wo.visit_task_id = c_task_id
4388: AND wo.wip_entity_id = wip.wip_entity_id
4389: AND opr.workorder_id = wo.workorder_id;
4390: