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 1306: ' from wip_operation_resources wor1, bom_department_resources bdr ' ||

1302: add_where(l_where,
1303: ' exists ' ||
1304: ' ( ' ||
1305: ' select 1 ' ||
1306: ' from wip_operation_resources wor1, bom_department_resources bdr ' ||
1307: ' where wor1.wip_entity_id = qrslt.wip_entity_id ' ||
1308: ' and wor1.organization_id = qrslt.organization_id ' ||
1309: ' and wor1.operation_seq_num = qrslt.operation_seq_num ' ||
1310: ' and bdr.department_id = qrslt.department_id ' ||

Line 1674: from bom_department_resources bdr, wip_parameters wp

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
1677: wp.organization_id = p_org_id;
1678: