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 399: FROM ahl_unit_effectivities_app_v sr_ue,

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

Line 400: ahl_unit_effectivities_app_v ue,

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