DBA Data[Home] [Help]

APPS.AHL_AMP_WORKBENCH_PVT dependencies on WIP_OPERATION_RESOURCES

Line 315: FROM wip_operation_resources wor,

311: CURSOR c_resource_req(c_oranization_id NUMBER,c_department_id NUMBER, c_on_date DATE, c_resource_id NUMBER)
312: IS
313: SELECT SUM (AHL_AMP_WORKBENCH_PVT.GET_DAY_REQUIREMENT(NVL(wor.usage_rate_or_amount,0),
314: NVL(wor.APPLIED_RESOURCE_UNITS,0),wor.organization_id,c_department_id,wor.start_date,wor.completion_date,c_on_date)) req_amt, wor.uom_code
315: FROM wip_operation_resources wor,
316: wip_discrete_jobs wdj,
317: wip_entities wip
318: WHERE wor.organization_id = c_oranization_id
319: AND wor.department_id = c_department_id