Oracle Finance Queries & Tables

Tables & Queries


select * from hz_customer_profiles where cust_account_id =1054;

select * from apps.hz_organizations_profiles;

select hca.account_name,hca.account_number,hcsu.freight_term,hcsu.site_use_code
from
hz_cust_accounts hca,
hz_cust_acct_sites_all hcas,
hz_cust_site_uses_all hcsu
where  hca.cust_account_id = hcas.cust_account_id
and hcas.cust_acct_site_id =hcsu.cust_acct_site_id
--and hca.cust_account_id =1054
and hcsu.site_use_code = 'BILL_TO'
and hcsu.status ='A'
order by 1;

--TRX_num
select * from apps.ra_customer_trx_all where customer_trx_id =3706;
select * from apps.RA_CUSTOMER_TRX_LINES_all where customer_trx_id =3706;
select * from apps.ar_adjustments_all where adjustment_number = 11002;
select * from apps.AR_PAYMENT_SCHEDULES_all where payment_schedule_id =1693;
select * from apps.RA_CUST_TRX_TYPES_all;