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.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on HZ_CUST_ACCOUNTS_ALL

Line 1382: FROM hz_cust_accounts_all hca,

1378: c_open_invs_rec c_open_invs%ROWTYPE;
1379:
1380: CURSOR c_get_cust_acct_num(cp_cash_receipt_id IN NUMBER) IS
1381: SELECT hca.account_number
1382: FROM hz_cust_accounts_all hca,
1383: ar_cash_receipts_all arcash
1384: WHERE hca.cust_account_id = arcash.pay_from_customer
1385: AND arcash.cash_receipt_id = cp_cash_receipt_id;
1386:

Line 1979: hz_cust_accounts_all hca

1975: b.cash_receipt_id icr_id,
1976: b.pay_from_customer customer_number
1977: FROM OKL_TRX_CSH_RECEIPT_V a,
1978: AR_CASH_RECEIPTS_ALL b,
1979: hz_cust_accounts_all hca
1980: WHERE a.cash_receipt_id = b.cash_receipt_id
1981: AND hca.account_number = cp_customer_num
1982: AND b.pay_from_customer = hca.cust_account_id
1983: AND a.fully_applied_flag = 'N';

Line 2059: hz_cust_Accounts_all hca

2055: CURSOR c_get_rcpt_id ( cp_receipt_number in VARCHAR2
2056: ,cp_customer_num in VARCHAR2) IS
2057: SELECT a.cash_receipt_id icr_id
2058: FROM AR_CASH_RECEIPTS a,
2059: hz_cust_Accounts_all hca
2060: WHERE a.receipt_number = l_receipt_num
2061: AND a.pay_from_customer = hca.cust_account_id
2062: AND hca.account_number = cp_customer_num;
2063: