APPS.WIP_WS_DL_UTIL dependencies on BOM_DEPARTMENT_RESOURCES

Line 432: from bom_department_resources bdr

428:
429: if( p_resource_id is not null ) then
430: select bdr.available_24_hours_flag
431: into l_24hr_resource
432: from bom_department_resources bdr
433: where bdr.department_id = p_dept_id and
434: bdr.resource_id = p_resource_id;
435: else
436: l_24hr_resource := null;

Line 737: bom_department_resources bdr,

733: from wip_discrete_jobs wdj,
734: wip_operations wo,
735: wip_operation_resources wor,
736: bom_resources br,
737: bom_department_resources bdr,
738: wip_parameters mp
739: where wdj.wip_entity_id = wo.wip_entity_id and
740: wdj.organization_id = wo.organization_id and
741: mp.organization_id = wdj.organization_id and

Line 1300: ' from wip_operation_resources wor1, bom_department_resources bdr ' ||

1296: add_where(l_where,
1297: ' exists ' ||
1298: ' ( ' ||
1299: ' select 1 ' ||
1300: ' from wip_operation_resources wor1, bom_department_resources bdr ' ||
1301: ' where wor1.wip_entity_id = qrslt.wip_entity_id ' ||
1302: ' and wor1.organization_id = qrslt.organization_id ' ||
1303: ' and wor1.operation_seq_num = qrslt.operation_seq_num ' ||
1304: ' and bdr.department_id = qrslt.department_id ' ||

Line 1657: from bom_department_resources bdr, wip_parameters wp

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
1660: wp.organization_id = p_org_id;
1661: