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_PP_RESRC_ASSIGN_PVT dependencies on WIP_OPERATIONS

Line 173: wip_operations wo

169: INTO x_employee_id
170: FROM
171: bom_dept_res_instances bdri,
172: wip_operation_resources wor,
173: wip_operations wo
174: ,ahl_workorders awo, ahl_operation_resources aor
175: , mtl_employees_current_view pf
176: ,bom_resource_employees bre
177: where awo.wip_entity_id = wor.wip_entity_id

Line 273: wip_operations wo

269: INTO x_employee_id, x_employee_name
270: from
271: bom_dept_res_instances bdri,
272: wip_operation_resources wor,
273: wip_operations wo
274: ,ahl_workorders awo, ahl_operation_resources aor
275: , mtl_employees_current_view pf
276: ,bom_resource_employees bre
277: where awo.wip_entity_id = wor.wip_entity_id

Line 1093: FROM AHL_Workorders a, wip_operations wo

1089: CURSOR c_work (x_id IN NUMBER,
1090: x_operation_seq_num IN NUMBER) IS
1091: SELECT a.wip_entity_id, wo.organization_id,
1092: wo.department_id
1093: FROM AHL_Workorders a, wip_operations wo
1094: WHERE a.wip_entity_id = wo.wip_entity_id
1095: AND wo.operation_seq_num = x_operation_seq_num
1096: AND a.workorder_id = x_id;
1097: /*

Line 1148: wip_operations WOP,

1144: SELECT
1145: TO_CHAR(WOP.FIRST_UNIT_START_DATE, 'ss'),
1146: TO_CHAR(WOP.LAST_UNIT_COMPLETION_DATE, 'ss')
1147: FROM
1148: wip_operations WOP,
1149: ahl_workorders AWO
1150: WHERE
1151: WOP.OPERATION_SEQ_NUM = p_op_seq
1152: AND WOP.wip_entity_id = AWO.wip_entity_id

Line 2056: -- Get Dept ID from WIP Operations.

2052: department_id FROM AHL_Workorders_V
2053: WHERE workorder_id = x_id;
2054: */
2055: -- Fix for bug# 6452479.
2056: -- Get Dept ID from WIP Operations.
2057: CURSOR c_work (x_id IN NUMBER,
2058: x_operation_seq_num IN NUMBER) IS
2059: SELECT a.wip_entity_id, wo.organization_id,
2060: wo.department_id

Line 2061: FROM AHL_Workorders a, wip_operations wo

2057: CURSOR c_work (x_id IN NUMBER,
2058: x_operation_seq_num IN NUMBER) IS
2059: SELECT a.wip_entity_id, wo.organization_id,
2060: wo.department_id
2061: FROM AHL_Workorders a, wip_operations wo
2062: WHERE a.wip_entity_id = wo.wip_entity_id
2063: AND wo.operation_seq_num = x_operation_seq_num
2064: AND a.workorder_id = x_id;
2065: /*

Line 2115: wip_operations WOP,

2111: SELECT
2112: TO_CHAR(WOP.FIRST_UNIT_START_DATE, 'ss'),
2113: TO_CHAR(WOP.LAST_UNIT_COMPLETION_DATE, 'ss')
2114: FROM
2115: wip_operations WOP,
2116: ahl_workorders AWO
2117: WHERE
2118: WOP.OPERATION_SEQ_NUM = p_op_seq
2119: AND WOP.wip_entity_id = AWO.wip_entity_id

Line 2934: ahl_workorders c , wip_discrete_jobs d, wip_operations e

2930: SELECT operation_resource_id,resource_sequence_num,
2931: operation_sequence_num,resource_id,b.workorder_operation_id,
2932: c.workorder_id,c.wip_entity_id, d.organization_id,department_id
2933: FROM ahl_operation_resources a, ahl_workorder_operations b,
2934: ahl_workorders c , wip_discrete_jobs d, wip_operations e
2935: WHERE a.WORKORDER_OPERATION_id = b.workorder_operation_id
2936: AND b.workorder_id = c.workorder_id
2937: AND c.wip_entity_id = d.wip_entity_id
2938: AND c.wip_entity_id = e.wip_entity_id