APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on WIP_DISCRETE_JOBS

Line 763: FROM AHL_WORKORDERS WO, WIP_DISCRETE_JOBS WIP

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

Line 2934: ahl_workorders c , wip_discrete_jobs d, wip_operations e

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