APPS.WIP_WS_UTIL dependencies on BOM_DEPARTMENT_RESOURCES

Line 172: from bom_department_resources bdr

168:
169: if( p_resource_id is not null ) then /* test if it has shifts or not */
170: select bdr.available_24_hours_flag
171: into l_24hr_resource
172: from bom_department_resources bdr
173: where bdr.resource_id = p_resource_id and
174: bdr.department_id = p_dept_id;
175: else
176: l_24hr_resource := 2;

Line 813: from bom_department_resources bdr

809: l_new_start_date := p_start_date;
810:
811: select bdr.available_24_hours_flag
812: into l_24hr_resource
813: from bom_department_resources bdr
814: where bdr.department_id = p_department_id
815: and bdr.resource_id = p_resource_id;
816:
817: if( l_24hr_resource = 1 /*yes*/ ) then

Line 922: bom_department_resources bdr,

918: decode(wp.include_resource_efficiency,
919: wip_constants.yes, nvl(bdr.efficiency, 1), 1)
920: into l_units, l_utilization, l_efficiency
921: from wip_operation_resources wor,
922: bom_department_resources bdr,
923: wip_parameters wp
924: where wor.organization_id = p_organization_id
925: and wor.wip_entity_id = p_wip_entity_id
926: and wor.operation_seq_num = p_op_seq_num