AR Tables

  R12 AR Tables

------------------------------------Vision Instance---------------------------------------------------------
-------------CUSTOMER--------------------------------------
select * from ra_customers_interface_all;

select * from ra_customer_profiles_interface;

select * from hz_cust_accounts
where account_name='Business World';

select * from hz_cust_acct_sites_all
where cust_account_id=3347
and org_id=204;

select * from hz_cust_site_uses_all hcsua
where hcsua.site_use_id=1000;
where hcsua.cust_acct_site_id=3634;

select * from ar_customers
where customer_name='World of Business';
-----------------TRANSACTION----------------------------------

select * from RA_INTERFACE_LINES_ALL;
RA_INTERFACE_SALESCREDITS
RA_INTERFACE_DISTRIBUTIONS
RA_INTERFACE_ERRORS (details about the failed records)
/

select * from RA_CUSTOMER_TRX_ALL
where printing_original_date is not null
and sold_to_customer_id=1000
and trx_number=10000069 ;

select * from RA_CUSTOMER_TRX_LINES_ALL
where customer_trx_id=1600;

select * from Ra_Cust_Trx_Line_Gl_Dist_All
where customer_trx_line_id in (1802);

select * from RA_CUST_TRX_TYPES_ALL;

select * from XLA_DISTRIBUTION_LINKS xdl
where xdl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
and xdl.source_distribution_id_num_1=1314;

------------------RECEIPT---------------------------------

select * from ar_payment_schedules_all
where customer_trx_id=1600;

select * from ar_cash_receipts_all;

select * from AR_RECEIVABLE_APPLICATIONS_ALL
where applied_customer_trx_id=1600;
and payment_schedule_id-1061;

select * from ar_adjustments_all;