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.ARRX_BRS dependencies on HZ_LOCATIONS

Line 107: v_drawee_city HZ_LOCATIONS.city%TYPE;

103: v_drawee_name hz_parties.party_name%TYPE;
104: v_drawee_number hz_cust_accounts.account_number%TYPE;
105: v_drawee_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
106: v_drawee_vat_reg_number HZ_CUST_SITE_USES.tax_reference%TYPE;
107: v_drawee_city HZ_LOCATIONS.city%TYPE;
108: v_drawee_state HZ_LOCATIONS.state%TYPE;
109: v_drawee_country HZ_LOCATIONS.country%TYPE;
110: v_drawee_postal_code HZ_LOCATIONS.postal_code%TYPE;
111: v_drawee_class AR_LOOKUPS.meaning%TYPE;

Line 108: v_drawee_state HZ_LOCATIONS.state%TYPE;

104: v_drawee_number hz_cust_accounts.account_number%TYPE;
105: v_drawee_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
106: v_drawee_vat_reg_number HZ_CUST_SITE_USES.tax_reference%TYPE;
107: v_drawee_city HZ_LOCATIONS.city%TYPE;
108: v_drawee_state HZ_LOCATIONS.state%TYPE;
109: v_drawee_country HZ_LOCATIONS.country%TYPE;
110: v_drawee_postal_code HZ_LOCATIONS.postal_code%TYPE;
111: v_drawee_class AR_LOOKUPS.meaning%TYPE;
112: v_drawee_category AR_LOOKUPS.meaning%TYPE;

Line 109: v_drawee_country HZ_LOCATIONS.country%TYPE;

105: v_drawee_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
106: v_drawee_vat_reg_number HZ_CUST_SITE_USES.tax_reference%TYPE;
107: v_drawee_city HZ_LOCATIONS.city%TYPE;
108: v_drawee_state HZ_LOCATIONS.state%TYPE;
109: v_drawee_country HZ_LOCATIONS.country%TYPE;
110: v_drawee_postal_code HZ_LOCATIONS.postal_code%TYPE;
111: v_drawee_class AR_LOOKUPS.meaning%TYPE;
112: v_drawee_category AR_LOOKUPS.meaning%TYPE;
113: v_drawee_location HZ_CUST_SITE_USES.location%TYPE;

Line 110: v_drawee_postal_code HZ_LOCATIONS.postal_code%TYPE;

106: v_drawee_vat_reg_number HZ_CUST_SITE_USES.tax_reference%TYPE;
107: v_drawee_city HZ_LOCATIONS.city%TYPE;
108: v_drawee_state HZ_LOCATIONS.state%TYPE;
109: v_drawee_country HZ_LOCATIONS.country%TYPE;
110: v_drawee_postal_code HZ_LOCATIONS.postal_code%TYPE;
111: v_drawee_class AR_LOOKUPS.meaning%TYPE;
112: v_drawee_category AR_LOOKUPS.meaning%TYPE;
113: v_drawee_location HZ_CUST_SITE_USES.location%TYPE;
114: v_issue_date RA_CUSTOMER_TRX.trx_date%TYPE;

Line 164: v_drawee_address1 HZ_LOCATIONS.address1%TYPE;

160: v_risk_elimination_days AR_RECEIPT_METHOD_ACCOUNTS.risk_elimination_days%TYPE;
161: v_remittance_date AR_TRANSACTION_HISTORY.trx_date%TYPE;
162: v_remittance_payment_method AR_RECEIPT_METHODS.name%TYPE;
163: v_creation_batch_name RA_BATCHES.name%TYPE;
164: v_drawee_address1 HZ_LOCATIONS.address1%TYPE;
165: v_drawee_address2 HZ_LOCATIONS.address2%TYPE;
166: v_drawee_address3 HZ_LOCATIONS.address3%TYPE;
167: v_drawee_contact VARCHAR2(100);
168: v_special_instructions RA_CUSTOMER_TRX.special_instructions%TYPE;

Line 165: v_drawee_address2 HZ_LOCATIONS.address2%TYPE;

161: v_remittance_date AR_TRANSACTION_HISTORY.trx_date%TYPE;
162: v_remittance_payment_method AR_RECEIPT_METHODS.name%TYPE;
163: v_creation_batch_name RA_BATCHES.name%TYPE;
164: v_drawee_address1 HZ_LOCATIONS.address1%TYPE;
165: v_drawee_address2 HZ_LOCATIONS.address2%TYPE;
166: v_drawee_address3 HZ_LOCATIONS.address3%TYPE;
167: v_drawee_contact VARCHAR2(100);
168: v_special_instructions RA_CUSTOMER_TRX.special_instructions%TYPE;
169: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;

Line 166: v_drawee_address3 HZ_LOCATIONS.address3%TYPE;

162: v_remittance_payment_method AR_RECEIPT_METHODS.name%TYPE;
163: v_creation_batch_name RA_BATCHES.name%TYPE;
164: v_drawee_address1 HZ_LOCATIONS.address1%TYPE;
165: v_drawee_address2 HZ_LOCATIONS.address2%TYPE;
166: v_drawee_address3 HZ_LOCATIONS.address3%TYPE;
167: v_drawee_contact VARCHAR2(100);
168: v_special_instructions RA_CUSTOMER_TRX.special_instructions%TYPE;
169: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;
170: v_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;

Line 484: ,hz_locations loc

480: FROM ra_cust_trx_types_all ctt
481: ,ra_customer_trx_all trx
482: ,hz_cust_acct_sites raa
483: ,hz_party_sites party_site
484: ,hz_locations loc
485: ,hz_cust_account_roles acct_role
486: ,hz_parties rel_party
487: ,hz_relationships rel
488: ,hz_cust_site_uses_all rasu