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_RESOURCE_EMPLOYEES

Line 673: bom_resource_employees bre,

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
675: WHERE bd.organization_id = p_organization_id
676: AND ( bd.disable_date IS NULL
677: OR (bd.disable_date > sysdate))

Line 732: --get the instance id for the person id from bom_resource_employees

728: --methods for the competence check competence_check(l_person_id) and competence_type_check(l_person_id)
729:
730:
731:
732: --get the instance id for the person id from bom_resource_employees
733: CURSOR l_inst_id_csr_type(p_person_id IN NUMBER,p_organization_id IN NUMBER) IS
734: SELECT bre2.instance_id
735: FROM bom_resource_employees bre2
736: WHERE bre2.person_id = p_person_id

Line 735: FROM bom_resource_employees bre2

731:
732: --get the instance id for the person id from bom_resource_employees
733: CURSOR l_inst_id_csr_type(p_person_id IN NUMBER,p_organization_id IN NUMBER) IS
734: SELECT bre2.instance_id
735: FROM bom_resource_employees bre2
736: WHERE bre2.person_id = p_person_id
737: AND bre2.organization_id = p_organization_id
738: AND bre2.effective_start_date <= sysdate
739: AND bre2.effective_end_date > sysdate

Line 795: FROM bom_resource_employees bre,

791: AND we.organization_id = woru.organization_id
792: ) AS WorkOrderName,
793: (
794: SELECT br.resource_code
795: FROM bom_resource_employees bre,
796: bom_resources br
797: WHERE bre.instance_id = woru.instance_id
798: AND bre.organization_id = woru.organization_id
799: AND bre.effective_start_date <= sysdate

Line 826: bom_resource_employees bre

822: woru.operation_seq_num,
823: woru.resource_seq_num
824: FROM wip_operation_resource_usage woru ,
825: wip_discrete_jobs wdj,
826: bom_resource_employees bre
827: WHERE bre.person_id = l_person_id
828: AND bre.effective_start_date <= sysdate
829: AND bre.effective_end_date > sysdate
830: AND woru.instance_id = bre.instance_id

Line 1298: FROM bom_resource_employees bre,

1294: AND we.organization_id = woru.organization_id
1295: ) AS WorkOrderName,
1296: (
1297: SELECT br.resource_code
1298: FROM bom_resource_employees bre,
1299: bom_resources br
1300: WHERE bre.instance_id = woru.instance_id
1301: AND bre.organization_id = woru.organization_id
1302: AND bre.effective_start_date <= sysdate

Line 1344: bom_resource_employees bre,

1340: wdj.firm_planned_flag as firm_status
1341: FROM wip_operation_resource_usage woru ,
1342: wip_discrete_jobs wdj,
1343: eam_work_order_details ewod,
1344: bom_resource_employees bre,
1345: per_people_f ppf
1346: WHERE ppf.person_id = p_person_id
1347: AND ppf.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
1348: AND ppf.EFFECTIVE_START_DATE <= sysdate