Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the common standard table structure of Oracle". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. INV (inventory)

Sub-inventory: mtl_secondary_inventories

Transaction processing: mtl_material_transactions mmt

Transaction source type: mtl_txn_source_types

Transaction type: mtl_transaction_types

Inventory organization view (with company): org_organization_definitions

Inventory organization base table: HR_ALL_ORGANIZATION_UNITS

Organization parameter: mtl_parameters

Transaction batch: MTL_TRANSACTION_LOT_NUMBERS

Transaction sequence: mtl_serial_numbers

Material: MTL_SYSTEM_ITEMS_B

Batch: mtl_lot_numbers

Location: MTL_ITEM_LOCATIONS

Accounting period: gl_periods

Material price: CST_ITEM_COSTS

Quantity of material available: mtl_onhand_quantities

Account alias: MTL_GENERIC_DISPOSITIONS

Inventory interval table: org_acct_periods

Material transaction processing interface table:

Mtl_TRANSACTIONS_INTERFACE

MTL_MATERIAL_TRANSACTIONS_TEMP

Mtl_transaction_lots_temp

. Get the transaction source:

BEGIN

Inv_object_genealogy.getsource (mmt.organization_id

Mmt.transaction_source_type_id

Mmt.transaction_source_id)

END

. Material handling line view: mtl_txn_request_lines_v

Sales order table on the line: mtl_sales_orders uses the txn_source_id of the line view associated with sales_order_id

. The existing quantity interface of inventory contains LPN.LPN_CONTEXT IN (1,9,11) in the sql when searching according to LPN.

. The transaction source is the sales order: mmt.trx_source_line_id = oe_order_lines_all.line_id

2. Value set

Fnd_flex_values_vl

Fnd_flex_value_sets

III. Lookup_code

Fnd_lookup_values_vl

IV. Suppliers

Vendor head Information: ap_suppliers

Supplier location Information: ap_supplier_sites_all

Supplier tax rate: hz_code_assignments

Supplier bank account number: iby_ext_bank_accounts

Supplier tax Information: zx_party_tax_profile

Supplier bank branch: iby_ext_bank_branches_v

Supplier Bank: iby_ext_banks_v

The owner of the bank account: iby_account_owners

Location of the bank account: iby_pmt_instr_uses_all

Supplier contact: ap_supplier_contacts

Supplier contact phone number and other information: hz_contact_points

Supplier location additional information: pos_supp_prof_ext_b

Vendor payment Information: iby_external_payees_all

5. HR (personnel)

Employee base table: per_people_f

Employee View: hr_employees

User: fnd_user

Employee assignment table: per_all_assignments_f

Employee schedule: per_jobs

Employee Job language Table: per_jobs_tl

Employee position table: per_all_positions

Employee position multilingual table: hr_all_positions_f_tl

Code: hr_lookups

Region: fnd_territories_tl

6. GL (general ledger)

Account section: gl_code_combinations

Account set table: gl_sets_of_books

Journal approval form: gl_je_batches

Journal entry table: gl_je_headers

Journal line table: gl_je_lines

Journal account balance table: gl_balances

Certificate classification table: gl_je_categories

Credential source table: gl_je_sources

General ledger import reference information table (association between GL and XLA): gl_import_references

Subledger header: xla_ae_headers

Sub-ledger line: xla_ae_lines

Subledger transaction entity information: xla_transaction_entities

Sub-ledger event table: xla_events xe-- restrictions on the need for customer consolidation (xe.process_status_code not in ('paired journal event F')

Subledger allocation connection information (association between XLA and AR): xla_distribution_links

Get the next period of the period: gl_period_statuses_pkg.get_next_period

7. AP (coping)

Invoice (invoice) header form: ap_invoices (ap_invoices_all)

Invoice line table: ap_invoice_lines (ap_invoice_lines_all)

Invoice (invoice) allocation line table: ap_invoice_distributions_all

Payment information table: ap_invoice_payments_all

Payment checklist: ap_checks_all

Payment schedule: ap_payment_schedules_all

Document table: ap_check_stocks_all

Branch table: ap_bank_branches

Bank account form: ap_bank_accounts_all

Write-off history table: AP_PREPAY_HISTORY_ALL

Write-off history allocation table: AP_PREPAY_APP_DISTS

8. FA (assets)

Asset information sheet: fa_additions

Asset category table: fa_categories

Statement of asset books: fa_books

Asset allocation information table: fa_distribution_history

Depreciation information table: fa_deprn_detail

Depreciation transaction table: fa_transaction_headers

Asset allocation location: fa_locations

9. AR (receivable)

Transaction batch form: ar_batches_all

Invoice receivable head table: ra_customer_trx_all

Invoice Receivable Line Table: ra_customer_trx_lines_all

Invoice Receivable Distribution form: ra_cust_trx_line_gl_dist_all

Collection information table: ar_cash_receipts_all

Write-off information table: ar_receivable_applications_all

Adjustment table: ar_payment_schedules_all

Accounting entry form: ar_adjustments_all

Payment schedule: ar_distributions_all

10. OE (sales module)

Sales order header table: oe_order_headers_all

Sales order line table: oe_order_lines_all

Customer information table: ra_customers= > ar_customers

Address information table: ra_addresses_all

User information table: ra_site_uses_all

Send information table: wsh_new_deliveries

Sales order status lookup:oe_lookups

Sales order head, line type: oe_transaction_types_tl

True FLOW_STATUS_CODE value of the sales order line:

L_line_status: = oe_line_status_pub.get_line_status (l.line_id

L.flow_status_code)

Shipping transaction table: wsh_delivery_details wdd

Material handling single line table: mtl_txn_request_lines mtrl

Material handling sheet: mtl_txn_request_headers mtrh

Delivery form: wsh_delivery_assignments wda

Associate with material transaction table: mtl_material_transactions mmt: wdd.transaction_id = mmt.transaction_id

Shipping transaction and material handling order correlation: wdd.move_order_line_id = mtrl.line_id

Mtrl.header_id = mtrh.header_id

Wdd.delivery_detail_id = wda.delivery_detail_id

PO (Procurement)

Purchase order header table: po_headers_all pha

Purchase order line table: po_lines_all pla

Purchase requisition header form: po_requisition_headers_all prh

Purchase requisition line table: po_requisition_lines_all prl prl

Purchase applicant form: per_people_f papf

Purchase requisition line type table: po_line_types plt

Allocation table: po_distributions_all

Sending table: po_releases_all

Purchase receiving header table: rcv_shipment_headers rsh

Purchase receiving row table: rcv_shipment_lines rsl

Purchase receiving transaction table: rcv_transactions

List of purchasing suppliers: po_vendors

Purchasing supplier location table: po_vendor_sites_all

Table association:

Prh.requisition_header_id = prl.requisition_header_id

-- Associated purchase applicants

Prh.preparer_id = papf.person_id

AND trunc (SYSDATE) BETWEEN papf.effective_start_date AND

Papf.effective_end_date

-- Associated purchase requisition line type

Plt.line_type_id = prl.line_type_id

-- Associated purchase order

Rsl.po_line_id = pla.po_line_id

Rsl.po_header_id = pha.po_header_id

Purchase receive transaction type

SELECT plc.lookup_code

Plc.lookup_type

Plc.displayed_field

Plc.description

Plc.enabled_flag

FROM po_lookup_codes plc

WHERE plc.lookup_type LIKE 'RCV TRANSACTION TYPE'

--

Applicant for purchase application:

SELECT per.full_name

Per.person_id employee_id

Per.employee_number employee_num

Pb.name

FROM per_workforce_current_x per, per_business_groups_perf pb

WHERE (per.business_group_id = pb.business_group_id AND

Per.assignment_type IN

('E'

Decode (nvl (fnd_profile.value ('HR_TREAT_CWK_AS_EMP'),' N')

'Y'

'C'

'E')

-- AND per.person_id = 1032

ORDER BY per.full_name

--

Purchase order line promised field value

Po_line_locations_all.PROMISED_DATE

12. XLE

Legal entity: xle_entity_profiles

XIII. Cost

Cost group: cst_cost_groups

14. Annex

Attachment main view: fnd_attached_docs_form_vl

Annex main table: fnd_attached_documents fad

Attachment table: fnd_documents fd

Attached short text table: fnd_documents_short_text fst

Attached long text table: fnd_documents_long_text

Attachment data type table: fnd_document_datatypes dat

Attachment category table: fnd_document_categories_tl dct

Table association:

Fad.document_id = fd.document_id

--

Dct.category_id = fd.category_id

AND dct.language = userenv ('LANG')

--

Fd.datatype_id = dat.datatype_id

AND dat.language = userenv ('LANG')

--

Fd.media_id = fst.media_id

15. WIP

Discrete task list: wip_discrete_jobs wdj

Work order table: wip_operations wo

Process department table: bom_departments bd

Discrete task name table: wip_entities

Mobile transaction processing: wip_move_transactions

Resource transaction table: wip_transactions

Table association:

--

Wdj.organization_id = wo.organization_id

AND wdj.wip_entity_id = wo.wip_entity_id

--

Bd.department_id = wo.department_id

16. QA

Quality collection schedule: qa_plans qp

Quality Collection elements PROMPT Table: qa_plan_chars qpc

Quality collection element name table: qa_chars qc

Quality Collection element Type Table: fnd_common_lookups fl

Table association:

Qp.plan_id = qpc.plan_id

Qpc.char_id = qc.char_id

Qc.char_type_code = fl.lookup_code

AND fl.lookup_type = 'ELEMENT_TYPE'

AND fl.application_id = 250

Seventeen. WMS

LPN: wms_license_plate_numbers

Content LPN table: wms_lpn_contents

Rules for selecting and issuing treasury: wsh_picking_rules

Material handling sheet: mtl_txn_request_headers h

Material handling single line table: mtl_txn_request_lines l

Material handling single-line distribution table: mtl_material_transactions_temp t

The value of the LPN_CONTEXT field in the LPN table, LOOKUP_TYPE:WMS_LPN_CONTEXT

Table association: h.header_id = l.header_id

L.line_id = t.move_order_line_id

Standard package

Material unit conversion: inv_convert.inv_um_convert-function: return conversion rate

This is the end of the content of "what are the common standard table structures of Oracle". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.