Oracle Base Tables and Interface Tables

Interface Tables	Base Tables
GL
gl_interface	gl_je_batches
gl_budget_interface	gl_je_headers
	gl_je_lines
	gl_je_sources
	gl_je_categories
	gl_sets_of_books
	gl_daily_rates
	gl_balances
	gl_periods
	go_period_sets
	gl_code_conbinations
RA CUSTOMERS
ra_customers_interface_all	hz_parties
ra_contact_phones_int_all	hz_cust_accounts
ra_customer_profiles_int_all	hz_cust_acct_sites_all
ra_customer_banks_int_all	hz_cust_sit_use_all
ra_cust_pay_method_int_all	hz_party_sites
	hz_locations
	hz_party_site_uses
	hz_customer_profiles
	hz_organization_profiles
	hz_party_relationships
RA INVOICES	hz_person_profiles
ra_interface_lines_all	ra_customer_trx_all
ra_interface_distributions_all	ra_customer_trx_lines_all
ra_interface_salescredits_all	ra_cust_trx_line_gl_dist_all
	ra_cust_trx_types_all
	ar_payment_schedules_all
	ra_batch_sources_All
	ar_vat_tax_all
	ra_terms
	ar_periods
	ar_period_types
HZ_PARTY_V2PUB.CREATE_ORGANIZATION
HZ_PARTY_V2PUB.CREATE_PERSON
HZ_LOCATION_V2PUB.CREATE_LOCATION
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE
HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT
HZ_CONTACT_POINT_V2PUB.CREATE_PHONE_CONTACT_POINT
HZ_CUST_ACCOUNT_ROLE_V2PUB
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE
JTF_NOTES_PUB.CREATE_NOTE
Auto Lock box (Receipt)
ar_payment_interface_all	ar_interim_cash_receipt_all
Conc. Prog. post quick cash	ar_interim_cash_rcpt_lines_all
	ar_cash_receipts_all
first records will be inserted into interim tabels. After validations it will be inserted into base tables.	ar_payment_schedules_all
	ar_cash_receipt_history_all
ar_interim_cash_receipts_all	ar_distribution_all
ar_interim_cash_rcp_lines_all	ar_payment_method_all
	ar_receivable_applications_all
ar_receipt_api_pub.create_cash	ar_payment_schedules_all
ar_receipt_api_pub.reverse
if lockbox not be used, alternate work around is thru api's
OM SALES ORDERS
oe_headers_iface_all	oe_order_headers_all
oe_lines_iface_all	oe_order_lines_all
oe_actions_iface_all	oe_order_sources
	oe_transaction_types_tl
	oe_transaction_types_all
INV
mtl_system_items_interface	mtl_system_items_b
mtl_item_categories_interface	mtl_system_items_tl
mtl_item_revisions_interface	mtl_item_locations
mtl_interface_errors	mtl_item_categories
	mtl_item_revisions_b
	mtl_parameters
	hr_all_organizations_units
	cst_item_costs
	qp_list_headers
	jft_rs_salesreps
WORKFLOW	OEXWFORD.WFT
	wf_items
	wf_process_activities
	wf_item_activity_statuses
	wf_item_types_tl
AP INVOICES
ap_invoices_interface	ap_invoices_all
ap_invoice_lines_interface	ap_invoice_distributions_all
	ap_payments_schedules_all
PO VENDORS
AP_SUPPLIERS_INT	po_vendors
AP_SUPPLIER_SITES_INT	po_vendor_sites_all
AP_SUP_SITE_CONTACT_INT	po_vendor_contacts
	AP_BANK_BRANCHES
	AP_BANK_ACCOUNTS_ALL
	AP_BANK_ACCOUNT_USES_ALL
	AP_TAX_CODES_ALL
	AP_AWT_GROUPS
PO REQUISITIONS
po_requistitions_interface_all	po_requisition_headers_all
po_req_dist_interface_all	po_requisition_lines_all
	po_req_distributions_all
PURCHASE ORDERS
po_headers_interface	po_headers_all
po_lines_interface	po_lines_all
po_distributions_interface	po_line_locations_all
	po_distributions_all
	Workflow access levels are defined as follows: 0-9: Reserved for Oracle Workflow 10-19: Reserved for Oracle Application Object Library 20-99: Reserved for Oracle E-Business Suite 100-999: Reserved for customer organizations 1000: Public
FA
fa_inv_interface	fa_additions_b
fa_production_interface	fa_additions_tl
fa_mass_additions	fa_books
	fa_deprn_summary
	fa_deprn_details
	fa_deprn_history
	fa_retirements
ATO(assemble to order)
PTO(pick to order)
PTO(pick to order)
PA
	pa_tasks
	pa_expenditure_items_all
	pa_expenditures_all
	pa_transaction_constrols
	pa_projects_all
	pa_budget_versions
	pa_resource_assigments
	hxc_time_categories
	hxc_timecard_hours_v
Cash Management
Bank Statement Interface
CE_STATEMENT_HEADERS_INT_ALL	fnd_flex_values FFV
CE_STATEMENT_LINES_INTERFACE	fnd_flex_value_sets
GL_INTERFACE