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 AHL_WORKORDERS

Line 91: FROM BOM_DEPT_RES_INSTANCES BDRI, AHL_OPERATION_RESOURCES AOR, AHL_WORKORDERS_V AWO

87:
88: IF (p_serial_number IS NOT NULL) THEN
89: /*SELECT DISTINCT(instance_id)
90: INTO x_serial_id
91: FROM BOM_DEPT_RES_INSTANCES BDRI, AHL_OPERATION_RESOURCES AOR, AHL_WORKORDERS_V AWO
92: WHERE BDRI.resource_id = AOR.resource_id
93: AND BDRI.department_id = AWO.department_id
94: AND AWO.workorder_id = p_workorder_id
95: AND AOR.operation_resource_id = p_oper_resrc_id

Line 157: PER_PERSON_TYPES PEPT, AHL_WORKORDERS AWV, AHL_VISITS_B VTB

153: IF (p_employee_number IS NOT NULL) THEN
154: /*SELECT DISTINCT(PPF.PERSON_ID)
155: INTO x_employee_id
156: FROM PER_PEOPLE_F PPF, BOM_RESOURCE_EMPLOYEES BRE, AHL_OPERATION_RESOURCES AOR,
157: PER_PERSON_TYPES PEPT, AHL_WORKORDERS AWV, AHL_VISITS_B VTB
158: WHERE PPF.PERSON_ID = BRE.PERSON_ID AND BRE.RESOURCE_ID = AOR.RESOURCE_ID
159: AND AWV.VISIT_ID = VTB.VISIT_ID
160: AND BRE.ORGANIZATION_ID = VTB.ORGANIZATION_ID
161: AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE

Line 174: ,ahl_workorders awo, ahl_operation_resources aor

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
178: and awo.workorder_id = p_workorder_id

Line 252: AHL_WORKORDERS AWV,

248: FROM PER_PEOPLE_F PPF,
249: BOM_RESOURCE_EMPLOYEES BRE,
250: AHL_OPERATION_RESOURCES AOR,
251: PER_PERSON_TYPES PEPT,
252: AHL_WORKORDERS AWV,
253: AHL_VISITS_B VTB
254: WHERE PPF.PERSON_ID = BRE.PERSON_ID
255: AND BRE.resource_id = AOR.resource_id
256: AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE

Line 274: ,ahl_workorders awo, ahl_operation_resources aor

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
278: and awo.workorder_id = p_workorder_id

Line 749: FROM AHL_WORKORDERS_V

745: /*
746: CURSOR c_job_date(job_id IN NUMBER) IS
747: SELECT TO_DATE(SCHEDULED_START_DATE,'DD-MM-YYYY'), TO_DATE(SCHEDULED_END_DATE,'DD-MM-YYYY'),
748: TO_DATE(ACTUAL_START_DATE,'DD-MM-YYYY'), TO_DATE(ACTUAL_END_DATE,'DD-MM-YYYY')
749: FROM AHL_WORKORDERS_V
750: WHERE workorder_id = job_id; */
751: --
752: /* CURSOR c_job_date(job_id IN NUMBER) IS
753: SELECT TRUNC(SCHEDULED_START_DATE), TRUNC(SCHEDULED_END_DATE),

Line 755: FROM AHL_WORKORDERS_V

751: --
752: /* CURSOR c_job_date(job_id IN NUMBER) IS
753: SELECT TRUNC(SCHEDULED_START_DATE), TRUNC(SCHEDULED_END_DATE),
754: TRUNC(ACTUAL_START_DATE), TRUNC(ACTUAL_END_DATE)
755: FROM AHL_WORKORDERS_V
756: WHERE workorder_id = job_id;
757: */
758: --Modified by srini for performance reasons
759: CURSOR c_job_date(job_id IN NUMBER) IS

Line 763: FROM AHL_WORKORDERS WO, WIP_DISCRETE_JOBS WIP

759: CURSOR c_job_date(job_id IN NUMBER) IS
760: SELECT TRUNC(WIP.SCHEDULED_START_DATE),
761: TRUNC(WIP.SCHEDULED_COMPLETION_DATE) SCHEDULED_END_DATE,
762: TRUNC(WO.ACTUAL_START_DATE), TRUNC(WO.ACTUAL_END_DATE)
763: FROM AHL_WORKORDERS WO, WIP_DISCRETE_JOBS WIP
764: WHERE WO.wip_entity_id = WIP.wip_entity_id
765: AND WO.workorder_id = job_id;
766:
767:

Line 1085: department_id FROM AHL_Workorders_V

1081:
1082: /*
1083: CURSOR c_work (x_id IN NUMBER) IS
1084: SELECT wip_entity_id, organization_id,
1085: department_id FROM AHL_Workorders_V
1086: WHERE workorder_id = x_id;
1087: */
1088: -- fix bug# 6452479. Dept. should default from Operation dept.
1089: CURSOR c_work (x_id IN NUMBER,

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 1102: FROM AHL_Workorders a, ahl_visits_b b

1098: --Modified by Srini for performance fix
1099: CURSOR c_work (x_id IN NUMBER) IS
1100: SELECT wip_entity_id, organization_id,
1101: department_id
1102: FROM AHL_Workorders a, ahl_visits_b b
1103: WHERE a.visit_id = b.visit_id
1104: AND workorder_id = x_id;
1105: */
1106: --

Line 1149: ahl_workorders AWO

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
1153: AND AWO.workorder_id = p_wo_id;

Line 2052: department_id FROM AHL_Workorders_V

2048:
2049:
2050: /*CURSOR c_work (x_id IN NUMBER) IS
2051: SELECT wip_entity_id,organization_id,
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.

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 2070: FROM AHL_Workorders a, ahl_visits_b b

2066: --Modified by Srini for Performance fix
2067: CURSOR c_work (x_id IN NUMBER) IS
2068: SELECT wip_entity_id,organization_id,
2069: department_id
2070: FROM AHL_Workorders a, ahl_visits_b b
2071: WHERE a.visit_id = b.visit_id
2072: AND workorder_id = x_id;
2073: */
2074:

Line 2116: ahl_workorders AWO

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
2120: AND AWO.workorder_id = p_wo_id;

Line 2922: FROM ahl_operation_resources a, ahl_workorder_operations b, ahl_workorders_v c

2918: IS
2919: SELECT operation_resource_id,resource_sequence_num,
2920: operation_sequence_num,resource_id,b.workorder_operation_id,
2921: c.workorder_id,wip_entity_id,organization_id,department_id
2922: FROM ahl_operation_resources a, ahl_workorder_operations b, ahl_workorders_v c
2923: WHERE a.WORKORDER_OPERATION_id = b.workorder_operation_id
2924: AND b.workorder_id = c.workorder_id
2925: AND a.operation_resource_id = c_oper_resource_id;
2926: */

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