DBA Data[Home] [Help]

APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on WIP_OPERATION_RESOURCES

Line 4764: FROM wip_operation_resources

4760: CURSOR wip_res_cur (c_wip_entity_id IN NUMBER,
4761: c_resource_id IN NUMBER)
4762: IS
4763: SELECT SUM(assigned_units)
4764: FROM wip_operation_resources
4765: WHERE wip_entity_id = c_wip_entity_id
4766: AND resource_id = c_resource_id;
4767: l_wip_entity_id NUMBER;
4768: l_wip_op_entity_id NUMBER;

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