DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on WIP_CONSTANTS

Line 1655: decode(wp.include_resource_utilization, wip_constants.yes, nvl(bdr.utilization, 1), 1)

1651: l_units := null;
1652: end if;
1653:
1654: select nvl(l_units, bdr.capacity_units),
1655: decode(wp.include_resource_utilization, wip_constants.yes, nvl(bdr.utilization, 1), 1)
1656: into l_units, l_utilizaiton
1657: from bom_department_resources bdr, wip_parameters wp
1658: where bdr.department_id = p_dept_id and
1659: bdr.resource_id = p_resource_id and