APPS.ARRX_BRS dependencies on HZ_PARTIES

Line 103: v_drawee_name hz_parties.party_name%TYPE;

99: v_open_entered_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
100: v_open_functional_amount AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;
101: v_assigned_entered_amount RA_CUSTOMER_TRX_LINES.extended_amount%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;

Line 105: v_drawee_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;

101: v_assigned_entered_amount RA_CUSTOMER_TRX_LINES.extended_amount%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;

Line 486: ,hz_parties rel_party

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
489: ,ap_bank_accounts_all aba
490: ,ce_bank_branches_v abb

Line 492: ,hz_parties party

488: ,hz_cust_site_uses_all rasu
489: ,ap_bank_accounts_all aba
490: ,ce_bank_branches_v abb
491: ,hz_cust_accounts cust_acct
492: ,hz_parties party
493: ,ce_bank_branches_v rabb
494: ,ce_bank_accounts cba
495: ,ce_bank_acct_uses raba
496: ,ar_lookups arl

Line 520: AND rel.subject_table_name(+) = ''HZ_PARTIES'''||

516: AND cba.bank_branch_id = rabb.branch_party_id (+)
517: AND trx.drawee_contact_id = acct_role.cust_account_role_id (+)
518: AND acct_role.party_id = rel.party_id (+)
519: AND rel.subject_id = rel_party.party_id(+)
520: AND rel.subject_table_name(+) = ''HZ_PARTIES'''||
521: 'AND rel.object_table_name(+) = ''HZ_PARTIES'''||
522: 'AND rel.directional_flag(+) = ''F'''||
523: 'AND rah.customer_trx_id = trx.customer_trx_id
524: AND rah.current_record_flag = ''Y'''||

Line 521: 'AND rel.object_table_name(+) = ''HZ_PARTIES'''||

517: AND trx.drawee_contact_id = acct_role.cust_account_role_id (+)
518: AND acct_role.party_id = rel.party_id (+)
519: AND rel.subject_id = rel_party.party_id(+)
520: AND rel.subject_table_name(+) = ''HZ_PARTIES'''||
521: 'AND rel.object_table_name(+) = ''HZ_PARTIES'''||
522: 'AND rel.directional_flag(+) = ''F'''||
523: 'AND rah.customer_trx_id = trx.customer_trx_id
524: AND rah.current_record_flag = ''Y'''||
525: 'AND arl.lookup_code = rah.status