DBA Data[Home] [Help]

APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on WIP_DISCRETE_JOBS

Line 4739: FROM wip_discrete_jobs wip

4735:
4736: CURSOR wip_disc_cur (c_org_id IN NUMBER)
4737: IS
4738: SELECT wip.wip_entity_id
4739: FROM wip_discrete_jobs wip
4740: WHERE wip.organization_id = c_org_id
4741: AND (p_start_date BETWEEN wip.scheduled_start_date
4742: AND wip.scheduled_completion_date
4743: OR

Line 4890: FROM wip_operation_resources wor, wip_operations wo, wip_discrete_jobs wdj,

4886: p_x_tp_dtls_tbl IN OUT NOCOPY Time_Period_Details_Tbl_Type
4887: ) IS
4888: CURSOR get_wip_req_dtls_csr IS
4889: SELECT wor.start_date, wor.completion_date, wor.assigned_units, wor.wip_entity_id
4890: FROM wip_operation_resources wor, wip_operations wo, wip_discrete_jobs wdj,
4891: AHL_WORKORDERS aw
4892: WHERE wor.resource_id = p_resource_id
4893: AND wo.department_id = p_dept_id
4894: AND wo.wip_entity_id = wor.wip_entity_id