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_AR_PAYMENT_PVT dependencies on OZF_REASON_CODES_VL

Line 1225: (SELECT SUBSTRB(name,1,30) FROM ozf_reason_codes_vl WHERE reason_code_id = oc.reason_code_id) as name

1221: -- Fix for Bug#11741663
1222: CURSOR csr_get_interface_attr_dtls (cv_claim_id IN NUMBER) IS
1223: SELECT oc.customer_reason, oc.customer_ref_number,
1224: oc.reason_code_id, osp.post_to_gl,
1225: (SELECT SUBSTRB(name,1,30) FROM ozf_reason_codes_vl WHERE reason_code_id = oc.reason_code_id) as name
1226: FROM ozf_sys_parameters_all osp,
1227: ozf_claims_all oc
1228: WHERE
1229: NVL(osp.org_id, -99) = NVL(oc.org_id, -99)

Line 1592: FROM ozf_reason_codes_vl

1588:
1589: -- Cursor to get claim reason name
1590: CURSOR csr_get_reason_name (cv_reason_code_id IN NUMBER) IS
1591: SELECT SUBSTRB(name,1,30) name
1592: FROM ozf_reason_codes_vl
1593: WHERE reason_code_id = cv_reason_code_id;
1594: --End:Bug:2781186
1595:
1596:

Line 1882: FROM ozf_reason_codes_vl

1878: AND display = 'Y';
1879:
1880: CURSOR csr_reason_code(cv_reason_code_id IN NUMBER) IS
1881: SELECT adjustment_reason_code
1882: FROM ozf_reason_codes_vl
1883: WHERE reason_code_id = cv_reason_code_id;
1884:
1885: CURSOR csr_root_claim_number(cv_root_claim_id IN NUMBER) IS
1886: SELECT claim_number