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 254: AHL_WORKORDERS AWV,

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

Line 276: ,ahl_workorders awo, ahl_operation_resources aor

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

Line 751: FROM AHL_WORKORDERS_V

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

Line 757: FROM AHL_WORKORDERS_V

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

Line 765: FROM AHL_WORKORDERS WO, WIP_DISCRETE_JOBS WIP

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

Line 1087: department_id FROM AHL_Workorders_V

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

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

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

Line 1151: ahl_workorders AWO

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

Line 2054: department_id FROM AHL_Workorders_V

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

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

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

Line 2118: ahl_workorders AWO

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

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

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

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