Thursday, December 13, 2012

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  

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect