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_ASSIGN_EMP_PUB dependencies on BOM_DEPARTMENTS

Line 670: FROM bom_departments bd,

666: SELECT DISTINCT
667: ppf.person_id,
668: ppf.full_name,
669: ppf.employee_number
670: FROM bom_departments bd,
671: bom_department_resources bdr,
672: bom_dept_res_instances bdri,
673: bom_resource_employees bre,
674: per_people_f ppf

Line 760: --get the department code for the department from bom_departments

756: br.unit_of_measure as uom_code
757: FROM bom_resources br
758: WHERE br.resource_id = p_resource_id;
759:
760: --get the department code for the department from bom_departments
761: CURSOR l_dept_code_csr_type(p_department_id IN NUMBER) IS
762: SELECT bd.department_code
763: FROM bom_departments bd
764: WHERE bd.department_id = p_department_id;

Line 763: FROM bom_departments bd

759:
760: --get the department code for the department from bom_departments
761: CURSOR l_dept_code_csr_type(p_department_id IN NUMBER) IS
762: SELECT bd.department_code
763: FROM bom_departments bd
764: WHERE bd.department_id = p_department_id;
765:
766: --get the workorders linked to the person id.(if not from woru, then from wori)
767: CURSOR l_workorder_instance_csr_type(l_person_id NUMBER) IS

Line 852: bom_departments bd

848: --cursor to get resource code actually assigned to this workorder
849: CURSOR l_res_code_assigned_csr_type(l_instance_id number) IS
850: SELECT woru.instance_id
851: FROM wip_operation_resource_usage woru ,
852: bom_departments bd
853: WHERE woru.wip_entity_id = p_wip_entity_id
854: AND woru.organization_id = p_organization_id
855: AND woru.operation_seq_num = p_operation_seq_num
856: AND woru.instance_id = l_instance_id;