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_DF_PVT dependencies on AHL_UE_DEFERRAL_DETAILS_V

Line 398: FROM ahl_ue_deferral_details_v

394:
395: CURSOR unit_effectivity_info_csr(p_unit_effectivity_id IN NUMBER) IS
396: SELECT mr_header_id,cs_incident_id,repetitive_mr_flag,orig_deferral_ue_id,ue_status_code,
397: def_status_code,manually_planned_flag
398: FROM ahl_ue_deferral_details_v
399: WHERE unit_effectivity_id = p_unit_effectivity_id
400: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;
401:
402: l_mr_header_id NUMBER;

Line 5007: FROM ahl_ue_deferral_details_v

5003: -- to fecth context information
5004: CURSOR context_info_csr(p_unit_effectivity_id IN NUMBER) IS
5005: SELECT due_date, mr_header_id,title,description,repetitive_mr_flag,cs_incident_id,cs_incident_number,
5006: cs_incident_summary,manually_planned_flag
5007: FROM ahl_ue_deferral_details_v
5008: WHERE unit_effectivity_id = p_unit_effectivity_id
5009: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;--this takes care of app_usage changes
5010:
5011: -- mr status meaning has to be fecthed seperately because function returns only code

Line 5371: FROM ahl_ue_deferral_details_v

5367:
5368: -- to fecth context information
5369: CURSOR applicable_ue_csr(p_unit_effectivity_id IN NUMBER) IS
5370: SELECT orig_deferral_ue_id,ue_status_code,def_status_code
5371: FROM ahl_ue_deferral_details_v
5372: WHERE unit_effectivity_id = p_unit_effectivity_id;
5373:
5374: l_orig_deferral_ue_id NUMBER;
5375: l_ue_status_code VARCHAR2(30);