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.OZF_CLAIM_PVT dependencies on AMS_USER_STATUSES_VL

Line 107: FROM ams_user_statuses_vl

103: IS
104: CURSOR system_status_csr(p_user_status_id IN NUMBER,
105: p_status_type IN VARCHAR2)IS
106: SELECT system_status_code
107: FROM ams_user_statuses_vl
108: WHERE system_status_type = p_status_type
109: AND user_status_id = p_user_status_id;
110:
111: BEGIN

Line 155: FROM ams_user_statuses_vl

151: x_return_status OUT NOCOPY VARCHAR2)
152: IS
153: CURSOR Get_Status_csr IS
154: SELECT user_status_id
155: FROM ams_user_statuses_vl
156: WHERE system_status_type = p_status_type
157: AND system_status_code = p_status_code
158: AND seeded_flag = 'Y';
159:

Line 6773: FROM ams_user_statuses_vl

6769:
6770: CURSOR status_count_csr(p_status_code in varchar2,
6771: p_user_status_id in number) IS
6772: SELECT count(user_status_id)
6773: FROM ams_user_statuses_vl
6774: WHERE system_status_type = G_CLAIM_STATUS
6775: AND system_status_code = p_status_code
6776: AND user_status_id = p_user_status_id
6777: AND enabled_flag = 'Y';