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_PRINT_PVT dependencies on AHL_VISIT_TASKS_B

Line 253: AHL_VISIT_TASKS_B VST,

249: DOC.FIGURE,
250: DOC.NOTE
251: FROM
252: AHL_WORKORDERS WO,
253: AHL_VISIT_TASKS_B VST,
254: AHL_DOCUMENT_ASSOS_V DOC
255: WHERE
256: WO.VISIT_TASK_ID = VST.VISIT_TASK_ID
257: AND VST.MR_ID = DOC.ASO_OBJECT_ID

Line 279: AHL_VISIT_TASKS_B VTS,

275: DOC.NOTE
276: FROM
277: AHL_WORKORDERS WO,
278: CSI_II_RELATIONSHIPS CSI,
279: AHL_VISIT_TASKS_B VTS,
280: AHL_DOCUMENT_ASSOS_V DOC
281: WHERE
282: WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID
283: AND VTS.INSTANCE_ID = CSI.SUBJECT_ID

Line 307: AHL_VISIT_TASKS_B VTS,

303: DOC.NOTE
304: FROM
305: AHL_WORKORDERS WO,
306: AHL_PC_ASSOCIATIONS PCA,
307: AHL_VISIT_TASKS_B VTS,
308: AHL_DOCUMENT_ASSOS_V DOC
309: WHERE
310: WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
311: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(VTS.INSTANCE_ID) = PCA.UNIT_ITEM_ID

Line 1293: ahl_visit_tasks_b vtsk

1289: from
1290: ahl_workorders wo,
1291: wip_discrete_jobs wipd,
1292: ahl_visits_b vst,
1293: ahl_visit_tasks_b vtsk
1294: where
1295: wo.visit_id = vst.visit_id and
1296: wo.wip_entity_id = wipd.wip_entity_id and
1297: wo.visit_task_id = vtsk.visit_task_id and

Line 2099: FROM CS_INCIDENTS_ALL_B CSIN, AHL_VISIT_TASKS_B TSK

2095: --FROM CS_INCIDENTS_ALL_B CSIN
2096: --WHERE CSIN.INCIDENT_ID = UE.cs_incident_id
2097: --)
2098: (SELECT CSIN.INCIDENT_NUMBER
2099: FROM CS_INCIDENTS_ALL_B CSIN, AHL_VISIT_TASKS_B TSK
2100: WHERE CSIN.INCIDENT_ID = TSK.SERVICE_REQUEST_ID
2101: AND TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID
2102: )
2103: INCIDENT_NUMBER,

Line 2214: ahl_visit_tasks_b tsk

2210: IS
2211: SELECT wo.WORKORDER_ID
2212: --FROM AHL_WORKORDERS_V
2213: FROM AHL_WORKORDERS WO,
2214: ahl_visit_tasks_b tsk
2215: WHERE wo.visit_task_id = tsk.visit_task_id
2216: AND wo.master_workorder_flag = 'N'
2217: AND WO.STATUS_CODE NOT IN ('7','12','14','15','17','22')
2218: AND tsk.UNIT_EFFECTIVITY_ID = c_ue_id

Line 2595: AHL_VISIT_TASKS_B VISIT_TASK,

2591: MTL_SYSTEM_ITEMS_KFV MTL ,
2592: CSI_ITEM_INSTANCES CSI ,
2593: CS_INCIDENTS_ALL_B CS,
2594: AHL_WORKORDERS WO,
2595: AHL_VISIT_TASKS_B VISIT_TASK,
2596: HZ_PARTIES PARTY ,
2597: CS_INCIDENT_TYPES_TL CS_TYPE,
2598: (SELECT INCIDENT_ID ,
2599: PARTY_ID ,

Line 2667: FROM AHL_VISIT_TASKS_B VST,

2663:
2664: CURSOR get_nr_mr (c_ue_id IN NUMBER) IS
2665: SELECT DISTINCT
2666: VST1.UNIT_EFFECTIVITY_ID
2667: FROM AHL_VISIT_TASKS_B VST,
2668: AHL_UNIT_EFFECTIVITIES_B UE,
2669: AHL_VISIT_TASKS_B VST1
2670: WHERE VST.SERVICE_REQUEST_ID = VST1.SERVICE_REQUEST_ID
2671: AND VST.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID

Line 2669: AHL_VISIT_TASKS_B VST1

2665: SELECT DISTINCT
2666: VST1.UNIT_EFFECTIVITY_ID
2667: FROM AHL_VISIT_TASKS_B VST,
2668: AHL_UNIT_EFFECTIVITIES_B UE,
2669: AHL_VISIT_TASKS_B VST1
2670: WHERE VST.SERVICE_REQUEST_ID = VST1.SERVICE_REQUEST_ID
2671: AND VST.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
2672: AND UE.UNIT_EFFECTIVITY_ID = c_ue_id;
2673:

Line 2697: AHL_VISIT_TASKS_B VST

2693: SELECT DISTINCT
2694: VST.UNIT_EFFECTIVITY_ID ,
2695: MRB.TITLE
2696: FROM AHL_MR_HEADERS_B MRB,
2697: AHL_VISIT_TASKS_B VST
2698: WHERE VST.SERVICE_REQUEST_ID = c_incident_id
2699: AND VST.MR_ID = MRB.MR_HEADER_ID;
2700:
2701: l_route_doc VARCHAR2(4000) := '

Line 2868: ahl_visit_tasks_b tsk

2864: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
2865: FROM csi_counter_associations cca,
2866: csi_counters_vl cc ,
2867: ahl_workorders WO ,
2868: ahl_visit_tasks_b tsk
2869: WHERE cca.counter_id = cc.counter_id
2870: AND wo.visit_task_id = tsk.visit_task_id
2871: AND source_object_code = ''CP''
2872: --AND source_object_id = wo.item_instance_id

Line 3008: AHL_VISIT_TASKS_B VST

3004: SELECT DISTINCT
3005: VST.UNIT_EFFECTIVITY_ID "UnitEffectivityId",
3006: MRB.TITLE "Title"
3007: FROM AHL_MR_HEADERS_B MRB,
3008: AHL_VISIT_TASKS_B VST
3009: WHERE VST.SERVICE_REQUEST_ID = :1
3010: AND VST.MR_ID = MRB.MR_HEADER_ID
3011: ';
3012:

Line 3101: FROM ahl_visit_tasks_b vst, ahl_unit_effectivities_b ue, ahl_workorders wo

3097: l_visit_id := p_object_id;
3098: BEGIN
3099: SELECT vst.unit_effectivity_id
3100: BULK COLLECT INTO l_ue_id_tbl
3101: FROM ahl_visit_tasks_b vst, ahl_unit_effectivities_b ue, ahl_workorders wo
3102: WHERE vst.visit_id = l_visit_id
3103: and vst.task_type_code = 'SUMMARY'
3104: and wo.visit_task_id = vst.visit_task_id
3105: and wo.status_code NOT IN ('7','12','14','15','17','22')

Line 3117: FROM ahl_visit_tasks_b

3113:
3114: BEGIN
3115: SELECT visit_id
3116: INTO l_visit_id
3117: FROM ahl_visit_tasks_b
3118: WHERE unit_effectivity_id = l_ue_id_tbl(1)
3119: AND NVL(status_code,'DELETED') <> 'DELETED'
3120: AND task_type_code = 'SUMMARY';
3121:

Line 3202: ahl_visit_tasks_b VST

3198:
3199: SELECT VST.unit_effectivity_id
3200: INTO l_ue_id_tbl(1)
3201: FROM ahl_workorders WO,
3202: ahl_visit_tasks_b VST
3203: WHERE WO.visit_task_id = VST.visit_task_id
3204: AND WO.workorder_id = l_wo_id_tbl(1);
3205:
3206: EXCEPTION

Line 3686: ahl_visit_tasks_b VT

3682: l_uc_id := AHL_PRD_PARTS_CHANGE_PVT.Get_UnitConfig_ID(l_wo_id);
3683: SELECT VT.instance_id
3684: INTO l_count_instance_id
3685: FROM ahl_workorders WO,
3686: ahl_visit_tasks_b VT
3687: WHERE WO.visit_task_id = VT.visit_task_id
3688: AND WO.workorder_id = l_wo_id;
3689:
3690: ELSIF (p_object_type = 'MR' OR p_object_type = 'NR')THEN

Line 3694: ahl_visit_tasks_b vt

3690: ELSIF (p_object_type = 'MR' OR p_object_type = 'NR')THEN
3691: SELECT WO.workorder_id, VT.INSTANCE_ID
3692: INTO l_wo_id, l_count_instance_id
3693: FROM ahl_workorders WO,
3694: ahl_visit_tasks_b vt
3695: WHERE wo.visit_task_id = vt.visit_task_id
3696: AND vt.task_type_code = 'SUMMARY'
3697: AND vt.UNIT_EFFECTIVITY_ID = p_object_id ;
3698:

Line 3795: ahl_visit_tasks_b vt

3791: BEGIN
3792: SELECT wo.workorder_id
3793: BULK COLLECT INTO l_wo_id_tbl
3794: FROM ahl_workorders wo,
3795: ahl_visit_tasks_b vt
3796: WHERE wo.visit_task_id = vt.visit_task_id
3797: AND vt.task_type_code = 'UNASSOCIATED'
3798: AND wo.status_code NOT IN ('7','12','14','15','17','22')
3799: AND vt.visit_id = l_visit_id;

Line 3814: ahl_visit_tasks_b vt

3810: BEGIN
3811: SELECT vt.task_type_code
3812: INTO l_task_type
3813: FROM ahl_workorders wo,
3814: ahl_visit_tasks_b vt
3815: WHERE wo.visit_task_id = vt.visit_task_id
3816: AND wo.workorder_id = l_wo_id_tbl(1);
3817: END;
3818:

Line 7855: (Select quantity from ahl_visit_tasks_b where visit_task_id = w.visit_task_id) NET_QUANTITY,

7851: DECODE(WIP.DATE_RELEASED, NULL, NULL, TO_CHAR(WIP.DATE_RELEASED,'YYYY-MM-DD')
7852: ||'T'
7853: ||TO_CHAR(WIP.DATE_RELEASED, 'hh24:mi:ss') ) DATE_RELEASED,
7854: --WIP.NET_QUANTITY ,
7855: (Select quantity from ahl_visit_tasks_b where visit_task_id = w.visit_task_id) NET_QUANTITY,
7856: --UE.ATA_CODE ,
7857: DECODE(RO.ENIGMA_ROUTE_ID, NULL, NULL, SUBSTR(route_no, instr(route_no, ':',1,1)+1)) ATA_CODE,
7858: -- fix for bug# 10016417
7859: --(SELECT CSIN.INCIDENT_NUMBER

Line 7864: FROM CS_INCIDENTS_ALL_B CSIN, AHL_VISIT_TASKS_B TSK

7860: --FROM CS_INCIDENTS_ALL_B CSIN
7861: --WHERE CSIN.INCIDENT_ID = UE.cs_incident_id
7862: --)
7863: /*(SELECT CSIN.INCIDENT_NUMBER
7864: FROM CS_INCIDENTS_ALL_B CSIN, AHL_VISIT_TASKS_B TSK
7865: WHERE CSIN.INCIDENT_ID = TSK.SERVICE_REQUEST_ID
7866: AND TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID
7867: )
7868: INCIDENT_NUMBER,*/

Line 7908: AHL_VISIT_TASKS_B TSK,

7904: CS_TYPE.NAME,
7905: CS_TL.SUMMARY,
7906: TSK.VISIT_TASK_ID
7907: FROM CS_INCIDENTS_ALL_B CS,
7908: AHL_VISIT_TASKS_B TSK,
7909: CS_INCIDENT_TYPES_TL CS_TYPE,
7910: CS_INCIDENTS_ALL_TL CS_TL
7911: WHERE CS.INCIDENT_ID = TSK.SERVICE_REQUEST_ID
7912: --AND TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID

Line 8336: ahl_visit_tasks_b tsk

8332: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
8333: FROM csi_counter_associations cca,
8334: csi_counters_vl cc ,
8335: ahl_workorders WO ,
8336: ahl_visit_tasks_b tsk
8337: WHERE cca.counter_id = cc.counter_id
8338: AND wo.visit_task_id = tsk.visit_task_id
8339: AND source_object_code = ''CP''
8340: --AND source_object_id = wo.item_instance_id