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_MR_HEADERS_B

Line 2379: FROM ahl_mr_headers_b MRB ,

2375: B.due_date DueDate ,
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 ,

Line 2679: AHL_MR_HEADERS_B MRB,

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
2683: START WITH ue_id = c_ue_id

Line 2696: FROM AHL_MR_HEADERS_B MRB,

2692: IS
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:

Line 2991: AHL_MR_HEADERS_B MRB,

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
2995: START WITH ue_id = :1

Line 3007: FROM AHL_MR_HEADERS_B MRB,

3003: l_child_nr_details VARCHAR2(1000) := '
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: ';