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 WIP_OPERATION_RESOURCE_USAGE

Line 824: FROM wip_operation_resource_usage woru ,

820: AND wor.resource_seq_num = woru.resource_seq_num
821: ) AS usage ,
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

Line 851: FROM wip_operation_resource_usage woru ,

847:
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

Line 1341: FROM wip_operation_resource_usage woru ,

1337: woru.instance_id,
1338: woru.organization_id,
1339: ppf.full_name as employee_name ,
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

Line 1411: FROM wip_operation_resource_usage woru

1407:
1408: --Added union to fetch data from WORI, since data may not exist in WORU during upgrade step when this API is called
1409: CURSOR l_assigned_hr_csr_type(p_wip_entity_id IN NUMBER,p_organization_id IN NUMBER,p_op_seq_num IN NUMBER,p_res_seq_num IN NUMBER) IS
1410: SELECT ROUND(NVL((woru.completion_date - woru.start_date)*24,0),2) as assigned_hours
1411: FROM wip_operation_resource_usage woru
1412: WHERE woru.serial_number IS NULL
1413: AND woru.instance_id IS NOT NULL
1414: AND woru.wip_entity_id = p_wip_entity_id
1415: AND woru.operation_seq_num = p_op_seq_num

Line 1429: FROM wip_operation_resource_usage woru1

1425: AND wori.operation_seq_num = p_op_seq_num
1426: AND wori.ORGANIZATION_ID = p_organization_id
1427: AND wori.resource_seq_num = p_res_seq_num
1428: AND NOT EXISTS (SELECT 1
1429: FROM wip_operation_resource_usage woru1
1430: WHERE woru1.serial_number IS NULL
1431: AND woru1.instance_id = wori.instance_id
1432: AND woru1.wip_entity_id = wori.wip_entity_id
1433: AND woru1.operation_seq_num = wori.operation_seq_num