Apps Important Tables

Ra_baORACLE APPS IMPORTANT TABLES “AR” Tables : 1. AP_BANK_ACCOUNTS_ALL 2. AP_BANK_BRANCHES 3. Ar_lookups 4. Ar_reciept_methods 5. Ar_reciept_classes 6. Ar_vat_tax 7. Ar_cash_reciept_history 8. Ar_batches 9. Ar_distribution_sets 10.Ar_payments_schedules 11.Ar_cash_reciepts_all 12.Gl_daily_conversion_types 13.HZ_CUST_ACCOUNTS 14.HZ_PARTIES 15.HZ_CUST_SITE_USES 16.Hz_cust_accounts 17.Hz_cust_site_uses 18.Hz_cust_acct_sites 19.Hz_party_sites 20.Hz_locations 21.Hz_relationships 22.Hz_cust_account_roles 23.Ra_customer_trx_all 24.Ra_cust_trx_types_all 25.ra_batch_sources_all 26.ra_terms 27.ra_batches 28.ra_customer_trx_lines_all. “AP” TABLES : 1. ap_invoices_all 2. ap_checks_all 3. ap_invoice_payments_all 4. ap_bank_accounts 5. ap_bank_branches 6. ap_holds_all 7. ap_holds_release_name 8. ap_terms 9. ap_terms_lines 10.ap_expense_report_headers_all 11.ap_expense_report_lines_all “INV”TABLES : ITEMS : 1. mtl_system_items_b

2. 3. 4. 5. 6.

Mtl_secondary_inventories Mtl_item_locations Mtl_item_categories Mtl_categories Mtl_parameters

Revisions : 1. Mtl_item_revisions 2. Mtl_on_hand_quantities Transactions : 1. 2. 3. 4.

Mtl_material_transactions Mtl_transaction_accounts Mtl_transaction_types Mtl_unit_of_measure

“OM” TABLES : 1. oe_order_headers_all 2. oe_oder_lines_all “PO” TABLES : 1. 2. 3. 4.

PO_HEADERS_ALL PO_LINES_ALL PO_VENDORS PO_VENDOR_SITES_ALL