Common Oracle EBS Data Tables

INV inventory
Organization:
1. The business unit, A/B/C branch, and A Has factories such as A1 and A2. The theme objective is to independently calculate the organization.
ORG, ORG_ID;
2. Inventory organization, such as manufacturer's warehouses, such as factories such as A1 and A2
Organization_id;

HR_ORGANIZATION_UNITS-
Org_organization_definitions
Mtl_subinventory _ inventory Organization Unit
MTL_PARAMETERS-inventory organization parameters (name is used directly without ID)
MTL_SYSTEM_ITEMS_ B-material information (same as above, the inventory organization name is applied)
MTL_SECONDARY_INVENTORIES-Sub-stock organization-
MTL_ITEM_LOCATTIONS-goods location-SUBINVENTROY_CODE

Mtl_Material_Transactions-(inventory) Material Transaction table
Cost mtl_transaction_accounts
Transaction_cost is the transaction cost;
ACTUAL_COST is the actual cost calculated by the cost algorithm, the main unit of measurement

Current quantity
Summary history (plus or minus total)
Mtl_Material_Transactions
MTL_ONHAND_QUANTITIES: the current table, organization/sub-inventory/goods location/item summary may be calculated first-in-first-out according to the pick database. If "negative inventory not allowed" is set, a negative number may not appear.

PO
Requisition header table
Po_Requisition_Headers_all
Row Table
Po_Requisition_lines_all
Purchase order
PO_HEADER_ALL
PO_LINES_ALL
This module is required for purchase receipt-return/inter-organization transfer/normal status
RCV_TRANSACTIONS
1. receive 100 units of goods and place them in the "waiting for Quality Control" Space
2. Accept/reject
3. Inventory/Return
There are three different statuses! For example, if 100 transactions are received, 80 are accepted for warehouse receiving, and 20 are returned, 80 are accepted/20 are returned.
Select TRANSACTION_TYPE, DESTINATION_TYPE_CODE from RCV_TRANSACTIONS
We can see the following stages:
A1.RECEIVE-processing ing
A2.ACCEPT-processing ing
A3.DELIERY-INVETORY (affects the inventory quantity)

In normal mode, MTL_MATERIAL_TRANSACTIONS is triggered.

Sales order
OE_ORDER_headers_all
SOLD_FROM_ORG_ID
SOLD_TO_ORG_ID is the customer Layer
SHIP_FROM_ORG_ID
SHIP_TO_ORG_ID is the customer receiving Layer
INVOICE_TO_ORG_ID is the client's single-layer
DELIVER_TO_ORG_ID
Related to the customer structure
Customer RA_customers
Customer Address Ra_Addresses
Address arrival site RA_SITE_USES_ALL
Address invoice arrival site
OE_ORDER_LINEs_all

GL creden
Gl_je_batches
Credential Date: default_1_tive_date
Accounting Period: DEFAULT_PERIOD_NAME
Sum of original currency creden: RUNNING_TOTAL_DR/CR such as USD
Summary of local currency creden: RUNNING_TOTAL_ACCOUNTED_DR/CR

Gl_je_headers head information
Batch Number: JE_BATCH_ID
Accounting Period: PERIOD_NAME
Currency: CURRENCY_CODE
Exchange rate type: CURRENCY_CONVERSION_TYPE
Exchange rate date: CURRENCY_CONVERSION_DATE
Set of books: SET_OF_BOOKS_ID. For details, refer to GL_SETS_OF_BOOKS.
Credential type: JE_CATEGORY refer to GL_JE_SOURCES
Credential Source: JE_SOURCE

Gl_je_lines
CODE_COMBINATION_ID account combination number

GL_BALANCES general ledger balance
PERIOD_NET_DR/CR Net Value
BEGIN_BALANCE_DR/CR initial amount

AR invoice receivable
RA_CUSTOMER_TRX_ALL
CUSTOMER_TRX_ID invoice No.
BILL_TO_SITE_USE_ID client receipt ID
PRIMARY_SALES_ID salesman
REFERENCE is an external number input box provided by Oracle. However, we do not recommend that you use REFERENCE due to version issues and length (<= 30). To use an external number, use a descriptive elastic domain.

RA_CUSTOMER_TRX_LINES_ALL
LINE_ID row number
INVENTORY_ITEM_ID can be null. For example, for non-material services, only the/tax line appears in DESCRIPTION.
DESCRIPTION
Quantity of QUANTITY_INVOICE invoicing
LINE_TYPE row type (General/tax)
EXTEND_PRICE the Bank amount
Note: tax lines are hidden rows, so there are at least two lines.

Collection status
AR_CASH_RECEIPTS_ALL (including non-collection information)
CASH_RECEIPT_ID internal code
RECEIPT_NUMBER receipt number
RECEIPT_DATE collection date
Total AMOUNT
RECEIPT_TYPE Cash/miscellaneous Cash/Misc
FUNCTIONAL_AMOUNT base currency metering amount
RECEIPTS on the UI
The write-off relationship is not a one-to-one correspondence, nor is it a write-off 100%, the Application button at the upper right of the UI
AR_RECEIVABLE_APPLICATIONS_ALL
APPLIED_CUSTOMER_TRX_ID invoice No.
APPLIED_CUSTOMER_TRX_LINE_ID invoice line number

Status app: Write-off/UNAPP: unverified
AMOUNT_APPLIED matched amount
Note: The time of the red rush Receipt Report is different from month. You must check AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY_ALL.

AP
Invoice on the UI
AP_INVOICES_ALL

Actual PAYMENT
AP_CHECKS_ALL

The write-off relationship is the same as that of AR, and the Payment button in the lower right corner
AP_INVOICE_PAYMENTS_ALL customer balance table, which is complex: for example, merging two users, receivables and payables, and prepayment

Asset information FA_ADDITIONS
Name
No.
Category
Quantity

Asset type
FA_CATEGORIES

Asset books
What is the relationship between FA_BOOK_CONTROLS and accounting books?
FA_BOOKS
Inquiry in UI
Mothed is the depreciation method (linear method/yield method)

FA_DISTRIBUTION_HISTORY assigns assignment to which department is used
LOCATION_ID Department joint query FA_LOCATIONS

Depreciation information (Allocation Method)
FA_DEPRN_DETAIL
Period_counter depreciation period no.

Depreciation transactions (new, rebuilt, transferred, and decommissioned)
FA_TRANSACTION_HEADERS

Select fnd_profile.VALUE ('org _ id') FROM DUAL
Select * from hr_operating_units hou where hou. organization_id = 204
-- Fnd
Select * from fnd_application
Select * from fnd_application_tl where application_id = 101
Select * from fnd_application_vl where application_id = 101
---- Value set
Select * from fnd_flex_value_sets
Select * from fnd_flex_values
Select * from fnd_flex_values_vl
---- Elastic domain
Select * from fnd_id_flexs
Select * from fnd_id_flex_structures where id_flex_code = 'Gl #'
Select * from fnd_id_flex_segments where id_flex_code = 'Gl # 'and id_flex_num = 50671

Select * from fnd_profile_options_vl
Select * from fnd_concurrent_programs program table
Select * from fnd_concurrent_requests request table
Select * from fnd_concurrent_processes table

-- Inv
Select * from org_organization_definitions inventory Organization
Select * from mtl_parameters organization Parameters
Select * from mtl_system_items_ B where inventory_item_id = 171 and organization_id = 204 Item table
Select * from mtl_secondary_inventories sub-stock
Select * from mtl_item_locations location
Select * from mtl_lot_numbers batch
Select * from mtl_onhand_quantities existing table
Select * from mtl_serial_numbers Sequence
Select * from mtl_material_transactions Material Transaction Records
Select * from mtl_transaction_accounts accounting entries
Select * from mtl_transaction_types transaction type
Select * from mtl_txn_source_types transaction Source Type
Select * from mfg_lookups ml where ml. LOOKUP_TYPE = 'mtl _ TRANSACTION_ACTION'

-- Po
Select * from po_requisition_headers_all Request Header
Select * from po_requisition_lines_all request line
Select * from po_headers_all order Header
Select * from po_lines_all order line
Select * from po_line_locations_all
Select * from po_distributions_all allocation
Select * from po_releases_all send
Select * from rcv_shipment_headers
Select * from rcv_shipment_lines purchase receiving line
Select * from rcv_transactions receives Transaction Processing
Select * from po_agents
Select * from po_vendors order
Select * from po_vendor_sites_all

-- Oe
Select * from ra_customers customer
Select * from ra_addresses_all address
Select * from ra_site_uses_all user

Select * from oe_order_headers_all sales head
Select * from oe_order_lines_all sales line

Select * from wsh_new_deliveries send
Select * from wsh_delivery_details
Select * from wsh_delivery_assignments

-- Gl
Select * from gl_sets_of_books general ledger
Select * from gl_code_combinations gcc where gcc. summary_flag = 'y' subject combination
Select * from gl_balances account balance
Select * from gl_je_batches credential batch
Select * from gl_je_headers credential Header
Select * from gl_je_lines credential line
Select * from gl_je_categories credential category
Select * from gl_je_sources credential Source
Select * from gl_summary_templates summary Template
Select * from gl_account_hierarchies summary template level

-- Ar
Select * from ar_batches_all transaction processing batch
Select * from ra_customer_trx_all Invoice header
Select * from ra_customer_trx_lines_all invoice line
Select * from ra_cust_trx_line_gl_dist_all invoice Distribution
Select * from ar_cash_receipts_all collection
Select * from ar_receivable_applications_all write-off
Select * from ar_payment_schedules_all invoice Adjustment
Select * from ar_adjustments_all accounting entries
Select * from ar_distributions_all payment plan

-- Ap
Select * from ap_invoices_all Invoice header
Select * from ap_invoice_distributions_all invoice line
Select * from ap_payment_schedules_all payment plan
Select * from ap_check_stocks_all document
Select * from ap_checks_all payment
Select * from ap_bank_branches bank
Select * from ap_bank_accounts_all bank account
Select * from ap_invoice_payments_all write-off