DBA Data[Home] [Help]

APPS.WIP_PROD_INDICATORS dependencies on BOM_DEPARTMENT_RESOURCES_V

Line 4568: from bom_department_resources_v bdrv,

4564: p_resource_id IN NUMBER,
4565: p_uom_code IN VARCHAR2
4566: ) IS
4567: select distinct organization_id, department_id, resource_id
4568: from bom_department_resources_v bdrv,
4569: mtl_units_of_measure muom
4570: where bdrv.organization_id = nvl(p_organization_id, organization_id)
4571: and bdrv.department_id = nvl(p_department_id, department_id)
4572: and bdrv.resource_id = nvl(p_resource_id, resource_id)