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_PARTIES

Line 156: l_customer_name hz_parties.party_name%TYPE; /tca uptake/

152: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
153: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
154: l_maturity_date DATE;
155: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
156: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
157: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
158: /* 6612301 */
159: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
160: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;

Line 1022: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */

1018: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1019: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1020: l_maturity_date DATE;
1021: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1022: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1023: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1024: l_location hz_cust_site_uses.location%TYPE;
1025: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1026: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;

Line 3789: hz_parties party

3785: FROM ar_cash_receipts_all cr,
3786: ar_receipt_methods rm,
3787: ar_receipt_classes rc,
3788: hz_cust_accounts hca,
3789: hz_parties party
3790: WHERE cr.cash_receipt_id = p_cash_receipt_id
3791: AND hca.party_id = party.party_id
3792: AND hca.cust_account_id = cr.pay_from_customer
3793: AND cr.receipt_method_id = rm.receipt_method_id

Line 4321: hz_parties party

4317:
4318: SELECT party.party_id
4319: INTO l_party_id
4320: FROM hz_cust_accounts hca,
4321: hz_parties party
4322: WHERE hca.party_id = party.party_id
4323: AND hca.cust_account_id = l_customer_id ;
4324:
4325: SELECT payment_channel_code

Line 4461: l_party_id hz_parties.party_id%type;

4457:
4458: l_customer_id ra_customer_trx.paying_customer_id%type;
4459: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4460: l_org_id ra_customer_trx.org_id%type;
4461: l_party_id hz_parties.party_id%type;
4462: l_trx_number ra_customer_trx.trx_number%type;
4463: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4464: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
4465:

Line 4483: hz_parties party

4479:
4480: SELECT party.party_id
4481: INTO l_party_id
4482: FROM hz_cust_accounts hca,
4483: hz_parties party
4484: WHERE hca.party_id = party.party_id
4485: AND hca.cust_account_id = l_customer_id ;
4486:
4487: SELECT payment_channel_code

Line 4612: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,

4608: p_maturity_date IN DATE DEFAULT NULL,
4609: p_postmark_date IN DATE DEFAULT NULL,
4610: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4611: /* tca uptake */
4612: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4613: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4614: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4615: /* 6612301 */
4616: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,

Line 4935: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,

4931: p_maturity_date IN DATE DEFAULT NULL,
4932: p_postmark_date IN DATE DEFAULT NULL,
4933: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4934: /* tca uptake */
4935: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4936: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4937: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
4938: DEFAULT NULL,
4939: /* 6612301 */

Line 7104: ,p_party_id IN hz_parties.party_id%TYPE

7100: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
7101: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
7102: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
7103: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
7104: ,p_party_id IN hz_parties.party_id%TYPE
7105: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE
7106: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
7107: ) IS
7108:

Line 7136: l_party_id hz_parties.party_id%TYPE;

7132: l_acctd_amount_applied_to NUMBER;
7133: l_org_return_status VARCHAR2(1);
7134: l_org_id NUMBER;
7135:
7136: l_party_id hz_parties.party_id%TYPE;
7137: l_party_name hz_parties.party_name%TYPE;
7138: l_party_number hz_parties.party_number%TYPE;
7139: l_party_site_id hz_party_sites.party_site_id%TYPE;
7140: l_party_address VARCHAR2(360);

Line 7137: l_party_name hz_parties.party_name%TYPE;

7133: l_org_return_status VARCHAR2(1);
7134: l_org_id NUMBER;
7135:
7136: l_party_id hz_parties.party_id%TYPE;
7137: l_party_name hz_parties.party_name%TYPE;
7138: l_party_number hz_parties.party_number%TYPE;
7139: l_party_site_id hz_party_sites.party_site_id%TYPE;
7140: l_party_address VARCHAR2(360);
7141: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;

Line 7138: l_party_number hz_parties.party_number%TYPE;

7134: l_org_id NUMBER;
7135:
7136: l_party_id hz_parties.party_id%TYPE;
7137: l_party_name hz_parties.party_name%TYPE;
7138: l_party_number hz_parties.party_number%TYPE;
7139: l_party_site_id hz_party_sites.party_site_id%TYPE;
7140: l_party_address VARCHAR2(360);
7141: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
7142: l_payment_method_name iby_payment_methods_vl.payment_method_name%TYPE;