DBA Data[Home] [Help]

APPS.AHL_AMP_WORKBENCH_PVT dependencies on WIP_DISCRETE_JOBS

Line 316: wip_discrete_jobs wdj,

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
320: AND wor.resource_id = c_resource_id