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 CS_INCIDENTS_ALL_B

Line 2095: --FROM CS_INCIDENTS_ALL_B CSIN

2091: --UE.ATA_CODE ,
2092: DECODE(RO.ENIGMA_ROUTE_ID, NULL, NULL, SUBSTR(route_no, instr(route_no, ':',1,1)+1)) ATA_CODE,
2093: -- fix for bug# 10016417
2094: --(SELECT CSIN.INCIDENT_NUMBER
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

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 2125: --CS_INCIDENTS_ALL_B CSIN ,

2121: AHL_ROUTES_B RO ,
2122: AHL_UNIT_EFFECTIVITIES_B UE ,
2123: --HZ_PARTIES HZ ,
2124: CSI_ITEM_INSTANCES CSI ,
2125: --CS_INCIDENTS_ALL_B CSIN ,
2126: --AHL_VISIT_TASKS_VL VTS ,
2127: AHL_WORKORDERS W ,
2128: (SELECT LOOKUP_CODE ,
2129: MEANING

Line 2593: CS_INCIDENTS_ALL_B CS,

2589: FROM
2590: AHL_UNIT_EFFECTIVITIES_B UE,
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,

Line 2960: -- (Select INCIDENT_NUMBER from CS_INCIDENTS_ALL_B where INCIDENT_ID = AVB.SERVICE_REQUEST_ID) "NonRoutineTitle",

2956: CSIS.SERIAL_NUMBER "SerialNumber",
2957: FLVT.MEANING "VisitType",
2958: HROU.NAME "Organization",
2959: BDPT.DESCRIPTION "Department",
2960: -- (Select INCIDENT_NUMBER from CS_INCIDENTS_ALL_B where INCIDENT_ID = AVB.SERVICE_REQUEST_ID) "NonRoutineTitle",
2961: MTLI.subinventory_code "SubInventory",
2962: DECODE(MSI.segment19, NULL, MTLI.concatenated_segments, INV_PROJECT.GET_LOCSEGS(MTLI.concatenated_segments)
2963: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)
2964: || INV_ProjectLocator_PUB.get_project_number(MSI.segment19)

Line 2967: (Select INCIDENT_NUMBER from CS_INCIDENTS_ALL_B where INCIDENT_ID = AVB.SERVICE_REQUEST_ID) "NonRoutineTitle"

2963: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)
2964: || INV_ProjectLocator_PUB.get_project_number(MSI.segment19)
2965: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)
2966: || INV_ProjectLocator_PUB.get_task_number(MSI.segment20)) "Locator",
2967: (Select INCIDENT_NUMBER from CS_INCIDENTS_ALL_B where INCIDENT_ID = AVB.SERVICE_REQUEST_ID) "NonRoutineTitle"
2968: FROM AHL_VISITS_B AVB,
2969: MTL_SYSTEM_ITEMS_B_KFV MTSB,
2970: CSI_ITEM_INSTANCES CSIS,
2971: FND_LOOKUP_VALUES_VL FLVT,

Line 7860: --FROM CS_INCIDENTS_ALL_B CSIN

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
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

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 7893: --CS_INCIDENTS_ALL_B CSIN ,

7889: AHL_ROUTES_B RO ,
7890: AHL_UNIT_EFFECTIVITIES_B UE ,
7891: --HZ_PARTIES HZ ,
7892: CSI_ITEM_INSTANCES CSI ,
7893: --CS_INCIDENTS_ALL_B CSIN ,
7894: --AHL_VISIT_TASKS_VL VTS ,
7895: AHL_WORKORDERS W ,
7896: (SELECT LOOKUP_CODE ,
7897: MEANING

Line 7907: FROM CS_INCIDENTS_ALL_B CS,

7903: (SELECT CS.INCIDENT_NUMBER,
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