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.CS_SR_STATUS_PROPAGATION_PKG dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 397: FROM ahl_unit_effectivities_app_v sr_ue,

393: WHERE service_request_id = p_service_request_id;
394:
395: CURSOR c_cmro_orders IS
396: SELECT ue.mr_header_id
397: FROM ahl_unit_effectivities_app_v sr_ue,
398: ahl_unit_effectivities_app_v ue,
399: ahl_ue_relationships uer
400: WHERE sr_ue.unit_effectivity_id = uer.ue_id
401: and uer.related_ue_id = ue.unit_effectivity_id

Line 398: ahl_unit_effectivities_app_v ue,

394:
395: CURSOR c_cmro_orders IS
396: SELECT ue.mr_header_id
397: FROM ahl_unit_effectivities_app_v sr_ue,
398: ahl_unit_effectivities_app_v ue,
399: ahl_ue_relationships uer
400: WHERE sr_ue.unit_effectivity_id = uer.ue_id
401: and uer.related_ue_id = ue.unit_effectivity_id
402: and sr_ue.cs_incident_id = p_service_request_id;