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;