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.AHL_PRD_RESOURCE_TRANX_PVT dependencies on AHL_WORKORDER_TASKS_V

Line 591: from ahl_workorder_tasks_v wo, ahl_workorder_operations awo, bom_departments bd,

587: */
588:
589: Select awo.workorder_operation_id, wop.department_id, bd.department_code,
590: wo.organization_id
591: from ahl_workorder_tasks_v wo, ahl_workorder_operations awo, bom_departments bd,
592: wip_operations wop
593: where wo.wip_entity_id = wop.wip_entity_id
594: and wop.operation_seq_num = c_Oper_seq
595: and wop.department_id = bd.department_id

Line 1566: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,

1562: PEPF.FULL_NAME ,
1563: AWOS.DEPARTMENT_NAME,
1564: AWOS.DEPARTMENT_ID,
1565: AWOS.ITEM_INSTANCE_ID
1566: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,
1567: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL
1568: WHERE AWAS.OPERATION_RESOURCE_ID = AOPR.OPERATION_RESOURCE_ID
1569: AND AWOP.WORKORDER_OPERATION_ID = AOPR.WORKORDER_OPERATION_ID
1570: AND AWOP.WORKORDER_ID = AWOS.WORKORDER_ID