DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on WIP_CONSTANTS

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

1668: l_units := null;
1669: end if;
1670:
1671: select nvl(l_units, bdr.capacity_units),
1672: decode(wp.include_resource_utilization, wip_constants.yes, nvl(bdr.utilization, 1), 1)
1673: into l_units, l_utilizaiton
1674: from bom_department_resources bdr, wip_parameters wp
1675: where bdr.department_id = p_dept_id and
1676: bdr.resource_id = p_resource_id and