DBA Data[Home] [Help]

APPS.ARRX_BRS dependencies on HZ_CUST_SITE_USES

Line 106: v_drawee_vat_reg_number HZ_CUST_SITE_USES.tax_reference%TYPE;

102: v_assigned_functional_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%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;

Line 113: v_drawee_location HZ_CUST_SITE_USES.location%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;
115: v_status_gl_date AR_TRANSACTION_HISTORY.gl_date%TYPE;
116: v_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
117: v_issued_by_drawee RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE;

Line 488: ,hz_cust_site_uses_all rasu

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
489: ,IBY_EXT_BANK_ACCOUNTS_V aba
490: ,IBY_FNDCPT_TX_EXTENSIONS ifte
491: ,iby_pmt_instr_uses_all ipiu
492: ,ce_bank_branches_v abb