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 772: from bom_department_resources bdr

768: l_new_start_date := p_start_date;
769:
770: select bdr.available_24_hours_flag
771: into l_24hr_resource
772: from bom_department_resources bdr
773: where bdr.department_id = p_department_id
774: and bdr.resource_id = p_resource_id;
775:
776: if( l_24hr_resource = 1 /*yes*/ ) then

Line 881: bom_department_resources bdr,

877: decode(wp.include_resource_efficiency,
878: wip_constants.yes, nvl(bdr.efficiency, 1), 1)
879: into l_units, l_utilization, l_efficiency
880: from wip_operation_resources wor,
881: bom_department_resources bdr,
882: wip_parameters wp
883: where wor.organization_id = p_organization_id
884: and wor.wip_entity_id = p_wip_entity_id
885: and wor.operation_seq_num = p_op_seq_num