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 275: wip_operations wo

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

Line 1095: FROM AHL_Workorders a, wip_operations wo

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

Line 1150: wip_operations WOP,

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

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

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

Line 2063: FROM AHL_Workorders a, wip_operations wo

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

Line 2117: wip_operations WOP,

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

Line 2936: ahl_workorders c , wip_discrete_jobs d, wip_operations e

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