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_SETTLEMENT_DOC_PVT dependencies on AMS_USER_STATUSES_VL

Line 1919: FROM ams_user_statuses_vl

1915: where claim_id= p_claim_id;
1916:
1917: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1918: SELECT user_status_id
1919: FROM ams_user_statuses_vl
1920: WHERE system_status_type = 'OZF_CLAIM_STATUS'
1921: AND default_flag = 'Y'
1922: AND system_status_code = cv_status_code;
1923:

Line 1960: ams_user_statuses_vl us

1956:
1957: CURSOR csr_custom_status_id(p_claim_id IN NUMBER, p_status_code IN VARCHAR2) IS
1958: SELECT close_status_id
1959: FROM ozf_claims_all oc,
1960: ams_user_statuses_vl us
1961: WHERE oc.claim_id = p_claim_id
1962: AND oc.close_status_id = us.user_status_id
1963: AND us.system_status_type = 'OZF_CLAIM_STATUS'
1964: AND us.system_status_code = p_status_code;