Wednesday, July 3, 2024

Main Interface and Base table in Oracle Apps R12

 Main Interface and Base table in Oracle Apps R12




GL Module (General Ledger Module tables in Oracle Apps R12)

Interface Table

Base Table

gl_interface

gl_budget_interface

gl_je_batches

gl_je_headers

gl_je_lines

gl_je_sources

gl_je_categories

gl_sets_of_books

gl_daily_rates

gl_balances

gl_periods

gl_period_sets

gl_code_conbinations


AR Module (Account Receivable Module tables in Oracle Apps R12)

Interface Table

Base Table

ra_customers_interface_all  

ra_contact_phones_int_all

ra_customer_profiles_int_all

hz_parties hz_cust_accounts

hz_cust_acct_sites_all

hz_cust_sit_use_all

hz_party_sites

hz_locations

hz_party_site_uses

hz_customer_profiles

hz_organization_profiles

hz_person_profiles


ra_interface_lines_all

ra_interface_distributions_all

ra_interface_salescredits_all

ra_customer_trx_all

ra_customer_trx_lines_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


OM Module (Order Management Module tables in Oracle Apps R12)

Interface Table

Base Table

oe_headers_iface_all

oe_lines_iface_all

oe_actions_iface_all

oe_order_headers_all

oe_order_lines_all

oe_order_sources

oe_transaction_types_tl

oe_transaction_types_all


INV Module (Inventory Module tables in Oracle Apps R12)

Interface Table

Base Table

mtl_system_items_interface

mtl_item_categories_interface

mtl_item_revisions_interface

mtl_interface_errors

mtl_system_items_b

mtl_system_items_tl

mtl_item_locations

mtl_item_categories

mtl_item_revisions_b

mtl_parameters

hr_all_organizations_units

cst_item_costs

qp_list_headers

jft_rs_salesreps


Workflow Tables tables in Oracle Apps R12

Interface Table

Base Table


wf_items

wf_process_activities

wf_item_activity_statuses

wf_item_types_tl


PO Module (Purchase Order tables in Oracle Apps R12)

Interface Table

Base Table

PO REQUISITIONS

po_requistitions_interface_all

po_req_dist_interface_all


PURCHASE ORDERS

po_headers_interface

po_lines_interface

po_distributions_interface



PO VENDORS

po_vendors

po_vendor_sites_all

po_vendor_contacts


PO REQUISITIONS

po_requisition_headers_all

po_requisition_lines_all

po_req_distributions_all



PURCHASE ORDERS

po_headers_all

po_lines_all

po_line_locations_all

po_distributions_all


AP Module (Account Payables tables in Oracle Apps R12)

Interface Table

Base Table

ap_invoices_interface

ap_invoice_lines_interface

ap_invoices_all

ap_invoice_distributions_all

ap_payments_schedules_all


FA Module (Fixed Asset tables in Oracle Apps R12)

Interface Table

Base Table

fa_inv_interface

fa_production_interface

fa_mass_additions

fa_additions_b

fa_additions_tl

fa_books

fa_deprn_summary

fa_deprn_details

fa_deprn_history

fa_retirements


PA  Module (Project Accounting in Oracle Apps R12)

Interface Table

Base Table


pa_tasks

pa_expenditure_items_all

pa_expenditures_all

pa_transaction_constrols

pa_projects_all

pa_budget_versions

pa_resource_assigments


TCA Architecture (Trading Community Architecture tables in Oracle Apps R12)

Interface Table

Base Table


hz_parties hz_cust_accounts

hz_cust_acct_sites_all

hz_cust_sit_use_all

hz_party_sites

hz_locations

hz_party_site_uses

hz_customer_profiles

hz_organization_profiles

hz_person_profiles


No comments:

Post a Comment

EBS : Package Development Process

====================== Package Specification ================================== CREATE OR REPLACE PACKAGE xx_emp_package IS     PROCEDURE lo...