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 WIP_OPERATIONS

Line 592: wip_operations wop

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
596: and wo.workorder_id = awo.workorder_id

Line 1018: From WIP_OPERATIONS WOP, AHL_WORKORDERS AW

1014: Select WOP.FIRST_UNIT_START_DATE, WOP.LAST_UNIT_COMPLETION_DATE,
1015: (select nvl(max(resource_seq_num),0) + 10 from wip_operation_resources
1016: where wip_entity_id = WOP.wip_entity_id and operation_seq_num = WOP.operation_seq_num),
1017: WOP.Department_id
1018: From WIP_OPERATIONS WOP, AHL_WORKORDERS AW
1019: Where AW.wip_entity_id = WOP.wip_entity_id
1020: and AW.workorder_id = p_workorder_id
1021: and WOP.operation_seq_num = p_operation_seq_num;
1022: