Pages

Sunday, May 21, 2017

Oracle Apps Tables

--------Multi Org Tables--------

hrfv_business_groups
gl_set_of_books/gl_ledgers
hr_legal_entities/xle_entity_profiles
hr_operating_units
org_organisation_definitions
mtl_secondary_inventories
mtl_item_locations

--------Procure to Pay---------

po_requisition_headers_all
po_requisition_lines_all
po_req_distributions_all

po_headers_all
po_lines_all
po_line_locations_all
po_distributions_all

ap_suppliers
ap_supplier_sites-all
ap_supplier_contacts

rcv_shipment_headers_all
rcv_shipment_lines_all
rcv_transactions

ap_invoices
ap_invoice_lines_all
ap_invoice_distributions_all

ap_invoice_payments_all
ap_checks_all
ap_payment_schedules_all
iby_payments_all
iby_pay_service_requests
iby_pay_instructions_all
ap_inv_selection_criteria_all

-------Order to Cash----------

oe_order_headers_all
oe_order_lines_all

wsh_delivery_details
wsh_delivery_assignments
wsh_new_deliveries
wsh_delivery_legs
wsh_trip_stops
wsh_trips

ra_customer_trx_all
ra_customer_trx_lines_all
ra_cust_trx_line_gl_dist_all
ra_cust_trx_line_salesreps_all

mtl_txn_req_headers_all
mtl_txn_req_lines_all

ar_cash_receipts_all
AR_RECEIVABLE_APPLICATIONS_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_CASH_RECEIPT_HISTORY_ALL

mtl_demand
mtl_reservations

qp_list_headers
qp_list_lines
qp_qualifiers
qp__pricing_attributes
qp_pricing_phases

-------Inventory----------


mtl_system_items_b
mtl_category_sets
mtl_categories
mtl_item_categories

mtl_onhand_quantitites
mtl_onhand_quantities_detail

mmt - mtl_material_transactions
mti- mtl_transactions_interface
mmtt - mtl_material_transactions_tem
mta- mtl_transaction_accounts


----------TCA-------------

Suppliers
-ap_suppliers
--hz_parties

-ap_supplier_sites_all
--hz_party_sites
--hz_party_site_uses
--hz_locations
--hz_parties

-ap_supplier_contacts
--hz_parties
--hz_party_sites
--hz_contact_points
--hz_org_contacts
--hz_relationships

Customers
-hz_cust_accounts
--hz_parties
-hz_cust_acct_sites_all
--hz_party_sites
--hz_locations

-hz_relationships
-hz_customer_profiles
-hz_customer_profile_classes

-------Banks and Branches--------

IBY_Ext_bank_accounts
IBY_ext_payees_all
iby_pmt_instr_uses_all

CE_BANK_ACCOUNTS
ce_bank_account_uses_all
CE_BANKS_V
CE_BANK_BRANCHES_V
HZ_PARTIES
HZ_RELATIONSHIPS
HZ_ORGANIZATION_PROFILE
HZ_CODE_ASSIGNMENTS

------General Ledger-----------

xla_ae_headers_all
xla_ae_lines_all
xla_distribution_links
xla_events


xla_trail_balances

gl_je_headers_all
gl_je_lines_all
gl_je_batches
gl_ledgers
gl_import_references

-----WIP Tables----------

WIP_PARAMETERS
WIP_DISCRETE_JOBS
WIP_ENTITIES
WIP_OPERATIONS
WIP_REQUIREMENT_OPERATIONS
WIP_OPERATION_RESOURCES
WIP_ACCOUNTING_CLASSES
WIP_EMPLOYEE_LABOR_RATES
WIP_INTERFACE_ERRORS
WIP_MOVE_TRANSACTIONS
WIP_MOVE_TXN_INTERFACE
WIP_OPERATION_OVERHEADS
WIP_OPERATION_RESOURCES
WIP_OPERATION_RESOURCE_USAGE
WIP_PERIOD_BALANCES
WIP_SHOP_FLOOR_STATUSES
WIP_SO_ALLOCATIONS
WIP_TRANSACTIONS
WIP_TRANSACTION_ACCOUNTS


------BOM Tables----------------

bom_bill_of_materials
bom_inventory_components
bom_reference_designators
bom_substitute_components
mtl_item_revisions
bom_operational_routings
bom_operation_sequences
bom_operation_resources
BOM_BILL_OF_MTLS_INTERFACE
BOM_INVENTORY_COMPS_INTERFACE
BOM_REF_DESGS_INTERFACE
BOM_SUB_COMPS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE
BOM_OP_ROUTINGS_INTERFACE
BOM_OP_SEQUENCES_INTERFACE
BOM_OP_RESOURCES_INTERFACE
MTL_RTG_ITEM_REVS_INTERFACE


------OPM Tables-------------------

gme_batch_header
gme_material_details



No comments:

Post a Comment