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.AR_RECEIPT_API_PUB dependencies on HZ_CUST_ACCOUNTS

Line 3835: hz_cust_accounts hca,

3831: pr.home_country
3832: FROM ar_cash_receipts_all cr,
3833: ar_receipt_methods rm,
3834: ar_receipt_classes rc,
3835: hz_cust_accounts hca,
3836: hz_parties party,
3837: /* Need to pass country code for SEPA specific receipts */
3838: ce_bank_acct_uses bau,
3839: ce_bank_accounts cba,

Line 4400: FROM hz_cust_accounts hca,

4396:
4397: ELSE
4398: SELECT party.party_id
4399: INTO l_party_id
4400: FROM hz_cust_accounts hca,
4401: hz_parties party
4402: WHERE hca.party_id = party.party_id
4403: AND hca.cust_account_id = l_customer_id ;
4404:

Line 4611: FROM hz_cust_accounts hca,

4607:
4608:
4609: SELECT party.party_id
4610: INTO l_party_id
4611: FROM hz_cust_accounts hca,
4612: hz_parties party
4613: WHERE hca.party_id = party.party_id
4614: AND hca.cust_account_id = l_customer_id ;
4615:

Line 4786: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,

4782: p_postmark_date IN DATE DEFAULT NULL,
4783: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4784: /* tca uptake */
4785: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4786: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4787: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4788: /* 6612301 */
4789: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
4790: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,

Line 5109: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,

5105: p_postmark_date IN DATE DEFAULT NULL,
5106: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5107: /* tca uptake */
5108: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
5109: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
5110: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
5111: DEFAULT NULL,
5112: /* 6612301 */
5113: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE

Line 12024: FROM hz_cust_accounts cust_acct,

12020: THEN
12021: BEGIN
12022: SELECT cust_acct.cust_account_id
12023: INTO l_customer_id
12024: FROM hz_cust_accounts cust_acct,
12025: hz_parties party
12026: WHERE cust_acct.party_id = party.party_id
12027: and cust_acct.cust_account_id = l_customer_id
12028: and cust_acct.status = 'A' ;

Line 12040: FROM hz_cust_accounts cust_acct,

12036: THEN
12037: BEGIN
12038: SELECT cust_acct.cust_account_id
12039: INTO l_customer_id
12040: FROM hz_cust_accounts cust_acct,
12041: hz_parties party
12042: WHERE cust_acct.party_id = party.party_id
12043: AND cust_acct.status = 'A'
12044: AND cust_acct.cust_account_id = l_customer_id

Line 12058: hz_cust_accounts acc

12054: AND r.bill_to_flag = 'Y'
12055: UNION
12056: SELECT rel.related_cust_account_id
12057: FROM ar_paying_relationships_v rel,
12058: hz_cust_accounts acc
12059: WHERE rel.party_id = acc.party_id
12060: AND acc.cust_account_id = l_rec_customer_id
12061: AND l_rec_date BETWEEN effective_start_date
12062: AND effective_end_date