eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_RES_VALIDATE_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 349: bom_department_resources bdr

345: 1 into g_dummy
346: from
347: wip_operations wo,
348: bom_departments bd,
349: bom_department_resources bdr
350: where
351: wo.organization_id = p_eam_res_rec.organization_id
352: and wo.wip_entity_id = p_eam_res_rec.wip_entity_id
353: and wo.operation_seq_num = p_eam_res_rec.operation_seq_num

Line 756: from bom_department_resources bdr

752: from mtl_parameters
753: where organization_id = p_eam_res_rec.organization_id;
754:
755: select available_24_hours_flag into l_24_hr_resource
756: from bom_department_resources bdr
757: where bdr.department_id = p_eam_res_rec.department_id
758: and bdr.resource_id = p_eam_res_rec.resource_id ;
759:
760: -- available_24_hours_flag is '1' for 24 hr resource and '2' for not 24 hr resource

Line 766: bom_department_resources bdr

762: if (l_24_hr_resource = 2) then
763: select count(rsh.shift_num) into l_count_shift_num
764: from bom_shift_times shf,
765: bom_resource_shifts rsh,
766: bom_department_resources bdr
767: where bdr.department_id = p_eam_res_rec.department_id
768: and bdr.resource_id = p_eam_res_rec.resource_id
769: and nvl(bdr.share_from_dept_id, bdr.department_id) = rsh.department_id
770: and bdr.resource_id = rsh.resource_id