APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on WIP_DISCRETE_JOBS

Line 765: FROM AHL_WORKORDERS WO, WIP_DISCRETE_JOBS WIP

761: CURSOR c_job_date(job_id IN NUMBER) IS
762: SELECT TRUNC(WIP.SCHEDULED_START_DATE),
763: TRUNC(WIP.SCHEDULED_COMPLETION_DATE) SCHEDULED_END_DATE,
764: TRUNC(WO.ACTUAL_START_DATE), TRUNC(WO.ACTUAL_END_DATE)
765: FROM AHL_WORKORDERS WO, WIP_DISCRETE_JOBS WIP
766: WHERE WO.wip_entity_id = WIP.wip_entity_id
767: AND WO.workorder_id = job_id;
768:
769:

Line 2936: ahl_workorders c , wip_discrete_jobs d, wip_operations e

2932: SELECT operation_resource_id,resource_sequence_num,
2933: operation_sequence_num,resource_id,b.workorder_operation_id,
2934: c.workorder_id,c.wip_entity_id, d.organization_id,department_id
2935: FROM ahl_operation_resources a, ahl_workorder_operations b,
2936: ahl_workorders c , wip_discrete_jobs d, wip_operations e
2937: WHERE a.WORKORDER_OPERATION_id = b.workorder_operation_id
2938: AND b.workorder_id = c.workorder_id
2939: AND c.wip_entity_id = d.wip_entity_id
2940: AND c.wip_entity_id = e.wip_entity_id