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 OZF_CUST_TRD_PRFLS

Line 655: FROM ozf_cust_trd_prfls

651: x_return_status OUT NOCOPY VARCHAR2)
652: IS
653: CURSOR days_due_csr(p_customer_account_id in number) IS
654: SELECT days_due
655: FROM ozf_cust_trd_prfls
656: WHERE cust_account_id = p_customer_account_id;
657:
658: -- fix for bug 5042046
659: CURSOR sys_parameters_days_due_csr IS

Line 1584: FROM OZF_CUST_TRD_PRFLS

1580: --trade profile based on the account id
1581: CURSOR get_cst_trd_prfl_wo_thr_csr(p_cust_account_id IN NUMBER) IS
1582: SELECT pos_write_off_threshold
1583: , neg_write_off_threshold
1584: FROM OZF_CUST_TRD_PRFLS
1585: WHERE cust_account_id = p_cust_account_id;
1586:
1587: --Cursor to get the Threshold amounts from the customers
1588: --Tradeprofile based on the party_id

Line 1592: FROM OZF_CUST_TRD_PRFLS

1588: --Tradeprofile based on the party_id
1589: CURSOR get_prt_trd_prfl_wo_thr_csr(p_party_id IN NUMBER) IS
1590: SELECT pos_write_off_threshold
1591: , neg_write_off_threshold
1592: FROM OZF_CUST_TRD_PRFLS
1593: WHERE party_id = p_party_id
1594: AND (pos_write_off_threshold is not null
1595: AND neg_write_off_threshold is not null)
1596: AND rownum = 1;

Line 3735: FROM ozf_cust_trd_prfls

3731: SELECT ozf_claims_all_s.nextval FROM dual;
3732:
3733: CURSOR trade_profile_csr(p_customer_account_id in number) IS
3734: SELECT vendor_id, vendor_site_id
3735: FROM ozf_cust_trd_prfls
3736: WHERE cust_account_id = p_customer_account_id;
3737:
3738: l_trade_profile trade_profile_csr%ROWTYPE;
3739: