Oracle Interface table and base table

Interface  Tables	Base Tables	Interface Tables	Base Tables	Interface Tables	Base Tables
GL		OM SALES ORDERS		AP INVOICES
gl_interface	gl_je_batches	oe_headers_iface_all	oe_order_headers_all	ap_invoices_interface	ap_invoices_all
gl_budget_interface	gl_je_headers	oe_lines_iface_all	oe_order_lines_all	ap_invoice_lines_interface	ap_invoice_distributions_all
	gl_je_lines	oe_actions_iface_all	oe_order_sources		ap_payments_schedules_all
	gl_je_sources		oe_transaction_types_tl	FA
	gl_je_categories		oe_transaction_types_all	fa_inv_interface	fa_additions_b
	gl_sets_of_books	INV		fa_production_interface	fa_additions_tl
	gl_daily_rates	mtl_system_items_interface	mtl_system_items_b	fa_mass_additions	fa_books
	gl_balances	mtl_item_categories_interface	mtl_system_items_tl		fa_deprn_summary
	gl_periods	mtl_item_revisions_interface	mtl_item_locations		fa_deprn_details
	go_period_sets	mtl_interface_errors	mtl_item_categories		fa_deprn_history
	gl_code_conbinations		mtl_item_revisions_b		fa_retirements
			mtl_parameters
RA CUSTOMERS			hr_all_organizations_units
ra_customers_interface_all	hz_parties		cst_item_costs	ATO(assemble to order)
ra_contact_phones_int_all	hz_cust_accounts		qp_list_headers	PTO(pick to order)
ra_customer_profiles_int_all	hz_cust_acct_sites_all		jft_rs_salesreps
	hz_cust_sit_use_all	WORKFLOW	OEXWFORD.WFT	PA
	hz_party_sites		wf_items		pa_tasks
	hz_locations		wf_process_activities		pa_expenditure_items_all
	hz_party_site_uses		wf_item_activity_statuses		pa_expenditures_all
	hz_customer_profiles		wf_item_types_tl		pa_transaction_constrols
	hz_organization_profiles	PO VENDORS			pa_projects_all
	hz_person_profiles		po_vendors		pa_budget_versions
RA INVOICES			po_vendor_sites_all		pa_resource_assigments
ra_interface_lines_all	ra_customer_trx_all		po_vendor_contacts
ra_interface_distributions_all	ra_customer_trx_lines_all	PO REQUISITIONS		OTL
ra_interface_salescredits_all	ra_cust_trx_line_gl_dist_all	po_requistitions_interface_all	po_requisition_headers_all		hxc_time_attributes
	ra_cust_trx_types_all	po_req_dist_interface_all	po_requisition_lines_all		hxc_time_attribute_usages
	ar_payment_schedules_all		po_req_distributions_all		hxc_time_building_blocks
	ra_batch_sources_All	PURCHASE ORDERS			hxc_time_categories
	ar_vat_tax_all	po_headers_interface	po_headers_all		hxc_timecard_hours_v
	ra_terms	po_lines_interface	po_lines_all
	ar_periods	po_distributions_interface	po_line_locations_all
	ar_period_types		po_distributions_all

Interface  Tables	Base Tables	Interface Tables	Base Tables	Interface Tables	Base Tables
GL		OM SALES ORDERS		AP INVOICES
gl_interface	gl_je_batches	oe_headers_iface_all	oe_order_headers_all	ap_invoices_interface	ap_invoices_all
gl_budget_interface	gl_je_headers	oe_lines_iface_all	oe_order_lines_all	ap_invoice_lines_interface	ap_invoice_distributions_all
	gl_je_lines	oe_actions_iface_all	oe_order_sources		ap_payments_schedules_all
	gl_je_sources		oe_transaction_types_tl	FA
	gl_je_categories		oe_transaction_types_all	fa_inv_interface	fa_additions_b
	gl_sets_of_books	INV		fa_production_interface	fa_additions_tl
	gl_daily_rates	mtl_system_items_interface	mtl_system_items_b	fa_mass_additions	fa_books
	gl_balances	mtl_item_categories_interface	mtl_system_items_tl		fa_deprn_summary
	gl_periods	mtl_item_revisions_interface	mtl_item_locations		fa_deprn_details
	go_period_sets	mtl_interface_errors	mtl_item_categories		fa_deprn_history
	gl_code_conbinations		mtl_item_revisions_b		fa_retirements
			mtl_parameters
RA CUSTOMERS			hr_all_organizations_units
ra_customers_interface_all	hz_parties		cst_item_costs	ATO(assemble to order)
ra_contact_phones_int_all	hz_cust_accounts		qp_list_headers	PTO(pick to order)
ra_customer_profiles_int_all	hz_cust_acct_sites_all		jft_rs_salesreps
	hz_cust_sit_use_all	WORKFLOW	OEXWFORD.WFT	PA
	hz_party_sites		wf_items		pa_tasks
	hz_locations		wf_process_activities		pa_expenditure_items_all
	hz_party_site_uses		wf_item_activity_statuses		pa_expenditures_all
	hz_customer_profiles		wf_item_types_tl		pa_transaction_constrols
	hz_organization_profiles	PO VENDORS			pa_projects_all
	hz_person_profiles		po_vendors		pa_budget_versions
RA INVOICES			po_vendor_sites_all		pa_resource_assigments
ra_interface_lines_all	ra_customer_trx_all		po_vendor_contacts
ra_interface_distributions_all	ra_customer_trx_lines_all	PO REQUISITIONS		OTL
ra_interface_salescredits_all	ra_cust_trx_line_gl_dist_all	po_requistitions_interface_all	po_requisition_headers_all		hxc_time_attributes
	ra_cust_trx_types_all	po_req_dist_interface_all	po_requisition_lines_all		hxc_time_attribute_usages
	ar_payment_schedules_all		po_req_distributions_all		hxc_time_building_blocks
	ra_batch_sources_All	PURCHASE ORDERS			hxc_time_categories
	ar_vat_tax_all	po_headers_interface	po_headers_all		hxc_timecard_hours_v
	ra_terms	po_lines_interface	po_lines_all
	ar_periods	po_distributions_interface	po_line_locations_all
	ar_period_types		po_distributions_all

Interface  Tables	Base Tables	Interface Tables	Base Tables	Interface Tables	Base Tables
GL		OM SALES ORDERS		AP INVOICES
gl_interface	gl_je_batches	oe_headers_iface_all	oe_order_headers_all	ap_invoices_interface	ap_invoices_all
gl_budget_interface	gl_je_headers	oe_lines_iface_all	oe_order_lines_all	ap_invoice_lines_interface	ap_invoice_distributions_all
	gl_je_lines	oe_actions_iface_all	oe_order_sources		ap_payments_schedules_all
	gl_je_sources		oe_transaction_types_tl	FA
	gl_je_categories		oe_transaction_types_all	fa_inv_interface	fa_additions_b
	gl_sets_of_books	INV		fa_production_interface	fa_additions_tl
	gl_daily_rates	mtl_system_items_interface	mtl_system_items_b	fa_mass_additions	fa_books
	gl_balances	mtl_item_categories_interface	mtl_system_items_tl		fa_deprn_summary
	gl_periods	mtl_item_revisions_interface	mtl_item_locations		fa_deprn_details
	go_period_sets	mtl_interface_errors	mtl_item_categories		fa_deprn_history
	gl_code_conbinations		mtl_item_revisions_b		fa_retirements
			mtl_parameters
RA CUSTOMERS			hr_all_organizations_units
ra_customers_interface_all	hz_parties		cst_item_costs	ATO(assemble to order)
ra_contact_phones_int_all	hz_cust_accounts		qp_list_headers	PTO(pick to order)
ra_customer_profiles_int_all	hz_cust_acct_sites_all		jft_rs_salesreps
	hz_cust_sit_use_all	WORKFLOW	OEXWFORD.WFT	PA
	hz_party_sites		wf_items		pa_tasks
	hz_locations		wf_process_activities		pa_expenditure_items_all
	hz_party_site_uses		wf_item_activity_statuses		pa_expenditures_all
	hz_customer_profiles		wf_item_types_tl		pa_transaction_constrols
	hz_organization_profiles	PO VENDORS			pa_projects_all
	hz_person_profiles		po_vendors		pa_budget_versions
RA INVOICES			po_vendor_sites_all		pa_resource_assigments
ra_interface_lines_all	ra_customer_trx_all		po_vendor_contacts
ra_interface_distributions_all	ra_customer_trx_lines_all	PO REQUISITIONS		OTL
ra_interface_salescredits_all	ra_cust_trx_line_gl_dist_all	po_requistitions_interface_all	po_requisition_headers_all		hxc_time_attributes
	ra_cust_trx_types_all	po_req_dist_interface_all	po_requisition_lines_all		hxc_time_attribute_usages
	ar_payment_schedules_all		po_req_distributions_all		hxc_time_building_blocks
	ra_batch_sources_All	PURCHASE ORDERS			hxc_time_categories
	ar_vat_tax_all	po_headers_interface	po_headers_all		hxc_timecard_hours_v
	ra_terms	po_lines_interface	po_lines_all
	ar_periods	po_distributions_interface	po_line_locations_all
	ar_period_types		po_distributions_all

http://www.itpub.net/thread-1795135-1-1.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12122734/viewspace-763437/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12122734/viewspace-763437/