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_UNIT_EFFECTIVITIES_B

Line 2055: (select job_number from ahl_workorders_v WO , AHL_UNIT_EFFECTIVITIES_B UE where

2051: UE.ata_code,
2052: WO.incident_number,
2053: HZ.party_name,
2054: --UE.originating_wo_id
2055: (select job_number from ahl_workorders_v WO , AHL_UNIT_EFFECTIVITIES_B UE where
2056: WO.workorder_id = UE.ORIGINATING_WO_ID
2057: and WO.unit_effectivity_id = UE.unit_effectivity_id) OriginatingWorkorder,
2058: WO.item_instance_id,
2059: decode(WO.plan_id,null,'F','T') isQualityEnabled

Line 2060: FROM AHL_WORKORDERS_V WO, WIP_DISCRETE_JOBS WIP, AHL_ROUTES_V RO, AHL_UNIT_EFFECTIVITIES_B UE, HZ_PARTIES HZ, CSI_ITEM_INSTANCES CSI

2056: WO.workorder_id = UE.ORIGINATING_WO_ID
2057: and WO.unit_effectivity_id = UE.unit_effectivity_id) OriginatingWorkorder,
2058: WO.item_instance_id,
2059: decode(WO.plan_id,null,'F','T') isQualityEnabled
2060: FROM AHL_WORKORDERS_V WO, WIP_DISCRETE_JOBS WIP, AHL_ROUTES_V RO, AHL_UNIT_EFFECTIVITIES_B UE, HZ_PARTIES HZ, CSI_ITEM_INSTANCES CSI
2061: WHERE WO.wip_entity_id = WIP.wip_entity_id
2062: AND WO.route_id = RO.route_id (+)
2063: AND UE.unit_effectivity_id(+) = WO.unit_effectivity_id
2064: AND CSI.instance_id = WO.ITEM_INSTANCE_ID(+)

Line 2111: --AHL_UNIT_EFFECTIVITIES_B UE1

2107: )
2108: PARTY_NAME,
2109: (SELECT WORKORDER_NAME
2110: FROM AHL_WORKORDERS WO --,
2111: --AHL_UNIT_EFFECTIVITIES_B UE1
2112: WHERE WO.WORKORDER_ID = UE.ORIGINATING_WO_ID
2113: --AND WO.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
2114: )
2115: ORIGINATINGWORKORDER,

Line 2122: AHL_UNIT_EFFECTIVITIES_B UE ,

2118: WO.ROUTE_ID
2119: FROM AHL_WORKORDER_TASKS_V WO ,
2120: WIP_DISCRETE_JOBS WIP ,
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 ,

Line 2380: ahl_unit_effectivities_b B,

2376: B.csi_item_instance_id ,
2377: MRB.mr_header_id ,
2378: MRB.last_update_date
2379: FROM ahl_mr_headers_b MRB ,
2380: ahl_unit_effectivities_b B,
2381: ahl_mr_intervals_v I ,
2382: fnd_lookup_values F1 ,
2383: csi_counter_template_vl C ,
2384: ahl_mr_headers_tl MRT ,

Line 2590: AHL_UNIT_EFFECTIVITIES_B UE,

2586: and wo.master_workorder_flag = 'Y'
2587: and wo.visit_task_id = visit_task.visit_task_id
2588: ) RELEASE_DATE
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,

Line 2653: FROM AHL_UNIT_EFFECTIVITIES_B UE,

2649: CURSOR get_child_ue (c_ue_id IN NUMBER) IS
2650: SELECT c_ue_id FROM DUAL
2651: union
2652: SELECT unit_effectivity_id
2653: FROM AHL_UNIT_EFFECTIVITIES_B UE,
2654: (
2655: SELECT related_ue_id
2656: FROM AHL_UE_RELATIONSHIPS
2657: START WITH ue_id = c_ue_id

Line 2668: AHL_UNIT_EFFECTIVITIES_B UE,

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
2672: AND UE.UNIT_EFFECTIVITY_ID = c_ue_id;

Line 2678: FROM AHL_UNIT_EFFECTIVITIES_B UE,

2674: CURSOR mr_child_details_csr(c_ue_id IN NUMBER)
2675: IS
2676: SELECT UE.unit_effectivity_id ,
2677: MRB.TITLE
2678: FROM AHL_UNIT_EFFECTIVITIES_B UE,
2679: AHL_MR_HEADERS_B MRB,
2680: (
2681: SELECT related_ue_id
2682: FROM AHL_UE_RELATIONSHIPS

Line 2763: --AHL_UNIT_EFFECTIVITIES_B UE,

2759: DOC.PAGE "Page" ,
2760: DOC.FIGURE "Figure" ,
2761: DOC.NOTE "Note"
2762: FROM AHL_DOCUMENT_ASSOS_V DOC ,
2763: --AHL_UNIT_EFFECTIVITIES_B UE,
2764: AHL_DOCUMENTS_V DOCV
2765: WHERE --UE.MR_HEADER_ID = DOC.ASO_OBJECT_ID
2766: DOC.ASO_OBJECT_ID = :1
2767: AND DOC.DOCUMENT_ID = DOCV.DOCUMENT_ID

Line 2990: FROM AHL_UNIT_EFFECTIVITIES_B UE,

2986:
2987: l_child_mr_details VARCHAR2(1000) :=
2988: 'SELECT unit_effectivity_id "UnitEffectivityId",
2989: MRB.TITLE "Title"
2990: FROM AHL_UNIT_EFFECTIVITIES_B UE,
2991: AHL_MR_HEADERS_B MRB,
2992: (
2993: SELECT related_ue_id
2994: FROM AHL_UE_RELATIONSHIPS

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 7879: --AHL_UNIT_EFFECTIVITIES_B UE1

7875: )
7876: PARTY_NAME,
7877: (SELECT WORKORDER_NAME
7878: FROM AHL_WORKORDERS WO --,
7879: --AHL_UNIT_EFFECTIVITIES_B UE1
7880: WHERE WO.WORKORDER_ID = UE.ORIGINATING_WO_ID
7881: --AND WO.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
7882: )
7883: ORIGINATINGWORKORDER,

Line 7890: AHL_UNIT_EFFECTIVITIES_B UE ,

7886: WO.ROUTE_ID
7887: FROM AHL_WORKORDER_TASKS_V WO ,
7888: WIP_DISCRETE_JOBS WIP ,
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 ,