DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS dependencies on HZ_CUST_ACCOUNTS

Line 123: hz_cust_accounts.cust_account_id%type,

119: ra_customer_trx.complete_flag%type,
120: p_open_receivables_flag IN
121: ra_cust_trx_types.accounting_affect_flag%type,
122: p_customer_id IN
123: hz_cust_accounts.cust_account_id%type,
124: p_site_use_id IN
125: hz_cust_site_uses.site_use_id%type,
126: p_gl_date IN
127: ra_cust_trx_line_gl_dist.gl_date%type,

Line 590: hz_cust_accounts cust_acct

586: p_primary_salesrep_number,
587: p_primary_salesrep_id
588: FROM ra_salesreps s,
589: ra_salesreps s1,
590: hz_cust_accounts cust_acct
591: WHERE cust_acct.primary_salesrep_id = s.salesrep_id(+)
592: AND cust_acct.cust_account_id = p_customer_id
593: AND DECODE(p_salesrep_required_flag,
594: 'Y', -3,