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_SITE_USES

Line 169: l_location hz_cust_site_uses.location%TYPE;

165: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
166: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
167: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
168: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
169: l_location hz_cust_site_uses.location%TYPE;
170: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
171: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
172: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
173: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;

Line 170: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;

166: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
167: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
168: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
169: l_location hz_cust_site_uses.location%TYPE;
170: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
171: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
172: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
173: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

Line 1035: l_location hz_cust_site_uses.location%TYPE;

1031: l_maturity_date DATE;
1032: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1033: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1034: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1035: l_location hz_cust_site_uses.location%TYPE;
1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1037: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1038: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1039: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;

Line 1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;

1032: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1033: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1034: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1035: l_location hz_cust_site_uses.location%TYPE;
1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1037: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1038: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1039: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

Line 4792: p_location IN hz_cust_site_uses.location%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,
4791: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4792: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4793: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4794: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
4795: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4796: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

Line 4793: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

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,
4791: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4792: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4793: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4794: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
4795: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4796: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4797: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,

Line 5118: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,

5114: DEFAULT NULL,
5115: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE
5116: DEFAULT NULL,
5117: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
5118: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
5119: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
5120: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
5121: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
5122: DEFAULT NULL,

Line 5119: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

5115: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE
5116: DEFAULT NULL,
5117: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
5118: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
5119: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
5120: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
5121: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
5122: DEFAULT NULL,
5123: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE

Line 12085: hz_cust_site_uses site_uses

12081: INTO l_location
12082: FROM hz_cust_acct_sites acct_site,
12083: hz_party_sites party_site,
12084: hz_locations loc,
12085: hz_cust_site_uses site_uses
12086: WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
12087: AND acct_site.party_site_id = party_site.party_site_id
12088: AND loc.location_id = party_site.location_id
12089: AND site_uses.site_use_code in ('BILL_TO','DRAWEE')