EBS常用表

--FA部分表

SELECT * FROM fa_impairments fi; --损耗表

SELECT * FROM fa_mass_additions fma; --成批增加表

SELECT * FROM fa_massadd_distributions fmd; --成批增加分配表

SELECT * FROM fa_additions_tl fat; --资产信息多语言表

SELECT * FROM fa_additions_b fab; --资产基本信息

SELECT * FROM fa_asset_history fah; --基本信息历史表

SELECT * FROM fa_distribution_history fdh; --资产分配表

SELECT * FROM fa_books fb; --财务信息表

SELECT * FROM fa_transaction_headers fth; --资产事务处理记录表

SELECT * FROM fa_category_books fcb; --类别对应账户信息表

SELECT * FROM fa_retirements fr; --报废表

SELECT * FROM fa_deprn_summary fds; --折旧汇总表

SELECT * FROM fa_deprn_detail fdd; --折旧明细表

SELECT * FROM fa_deprn_periods fdp; --折旧期间表

SELECT * FROM fa_additions;--资产信息表

SELECT * FROM fa_categories;--资产类别表

SELECT * FROM fa_books;--资产账簿表

SELECT * FROM fa_distribution_history;--资产分配信息表

SELECT * FROM fa_book_controls;

--支出类型OU

SELECT *

FROM hr_organization_information h

WHERE h.org_information1 = 'PA_EXPENDITURE_ORG';

--PA部分表

SELECT * FROM  pa_project_asset_lines_all; --项目资产行表

SELECT * FROM pa_project_assets_all;

SELECT * FROM PA_EXPENDITURE_ITEMS_ALL;--项目支出

SELECT * FROM PA_EXPENDITURES_ALL;

SELECT * FROM pa_pay_audit_all;

SELECT * FROM pa_project_asset_line_details;

--HR部分表

SELECT * FROM hr.pay_all_payrolls_f;--薪资明细表

SELECT * FROM hr_locations_all;--人员地址信息

SELECT * FROM hr_all_people_f;--人员基本信息

SELECT * FROM per_person_types;--人员类型信息

SELECT * FROM per_special_info_types;--人员特殊信息类型表

SELECT * FROM hr_all_organization_units;--组织表1

SELECT * FROM HR_OPERATING_UNITS;

SELECT * FROM pay_payroll_actions;--保险信息表

SELECT * FROM per_contracts_f;--员工合同信息

SELECT * FROM per_person_analyses;--人员特殊信息

SELECT * FROM per_org_structure_elements;--组织层次表

SELECT * FROM per_all_assignments_f;--员工分配信息

SELECT * FROM pay_people_groups;--人员组表

SELECT * FROM per_jobs;--职务表

SELECT * FROM per_grades;--等级表

SELECT * FROM per_all_positions;--职位表

SELECT * FROM per_assignment_status_types;--员工分配状态信息表

SELECT * FROM per_analysis_criteria;--特殊信息明细表

SELECT * FROM per_periods_of_service;--雇佣

--GL部分表

SELECT * FROM gl_je_batches;--日记账批

SELECT * FROM gl_je_headers;--日记账头信息

SELECT * FROM gl_je_lines;--日记账行明细

SELECT * FROM gl_sets_of_books;--总账账簿

SELECT * FROM GL_LEDGERS_V;

SELECT * FROM gl_code_combinations;--账户组合

SELECT * FROM gl_code_combinations_kfv;

SELECT * FROM gl_balances;--科目余额

SELECT * FROM gl_je_sources;--日记账来源

SELECT * FROM gl_je_categories;--日记账分类

SELECT * FROM gl_summary_templates;--科目汇总模板

SELECT * FROM gl_account_hierarchies;--科目汇总模板层次

SELECT * FROM gl_period_statuses;--总账会计期间

SELECT * FROM gl_period_sets;

SELECT * FROM gl_access_set_ledgers;

SELECT * FROM gl_import_references;--总账-xla

SELECT * FROM gl_interface;--总账标准接口表

SELECT * FROM gl_daily_rates;--汇率

SELECT * FROM gl_daily_balances;

--AP 部分表

SELECT * FROM ap_invoices_all;--应付发票

SELECT * FROM ap_invoice_lines_all;--应付发票行

SELECT * FROM ap_invoice_distributions_all;--应付发票分配行

SELECT * FROM ap_checks_all;--应付付款

SELECT * FROM ap_payment_schedules_all;

SELECT * FROM ap_check_stocks_all;--应付票据

SELECT * FROM ap_bank_branches;

SELECT * FROM ap_bank_accounts_all;

SELECT * FROM ap_bank_account_uses_all;

SELECT * FROM ap_bank_charges;

SELECT * FROM ap_bank_charge_lines;

SELECT * FROM ap_invoice_payments_all;--核销

SELECT * FROM ap_payment_history_all;

SELECT * FROM ap_payment_hist_dists;

--AR部分表

SELECT * FROM ar_batches_all;--事务处理批

SELECT * FROM ra_customer_trx_all;--事务处理

SELECT * FROM ra_customer_trx_lines_all;--事务处理行

SELECT * FROM ra_cust_trx_line_gl_dist_all;--事务处理分配

SELECT * FROM ar_cash_receipts_all;--收款

SELECT * FROM ar_receivable_applications_all;--核销

SELECT * FROM ar_payment_schedules_all;

SELECT * FROM ar_adjustments_all;

SELECT * FROM ar_distributions_all;

SELECT * FROM ar_misc_cash_distributions_all;--杂项分配表

SELECT * FROM ar_cash_receipt_history_all;--收款历史表

SELECT * FROM ar_receipt_method_accounts_all;--收款方法账户

SELECT * FROM ar_receipt_methods;--收款方法

SELECT * FROM ar_memo_lines_all_b;--通知单行

SELECT * FROM ar_memo_lines_all_tl;

SELECT * FROM hz_parties;--客户组织表

SELECT * FROM hz_cust_accounts;--客户编号表

SELECT * FROM hz_party_sites ;--组织地点表

SELECT * FROM hz_cust_acct_sites_all;---客户地点表

SELECT * FROM hz_cust_site_uses_all;--客户地点用途表

SELECT * FROM hz_code_assignments;

SELECT * FROM hz_organization_profiles;

SELECT * FROM hz_relationships;

SELECT * FROM hz_code_assignments;

SELECT * FROM hz_contact_points;

SELECT * FROM ce_bank_accounts;

SELECT * FROM ce_bank_acct_uses_all;

SELECT * FROM ce_bank_branches_v;

SELECT * FROM iby_ext_bank_accounts;-- 银行账户

--PO部分表

SELECT * FROM po_headers_all;--采购订单头

SELECT * FROM po_lines_all;--采购订单行

SELECT * FROM po_distributions_all;--采购订单分配表

SELECT * FROM po_line_locations_all;

SELECT * FROM po_releases_all;--

SELECT * FROM rcv_shipment_headers;--

SELECT * FROM rcv_shipment_lines;

SELECT * FROM rcv_transactions;--接收事务处理

SELECT * FROM po_agents;

SELECT * FROM po_vendors;--供应商

SELECT * FROM po_vendor_sites_all;

SELECT * FROM po_vendor_contacts;

SELECT * FROM PO_REQUISITION_LINES_ALL;--请购单行表

SELECT * FROM po_requisition_headers_all;--请购单头表

SELECT * FROM po_req_distributions_all;--请购分配

select * from po_releases_all--发送

SELECT * from rcv_shipment_headers--采购接收头

SELECT * from rcv_shipment_lines--采购接收行

SELECT * from rcv_transactions--接收事务处理

--INV部分表

SELECT * FROM org_organization_definitions;--库存组织

SELECT * FROM mtl_parameters;--组织参数

SELECT * FROM mtl_system_items_b;--物料表

SELECT * FROM mtl_secondary_inventories;--子库存

SELECT * FROM mtl_item_locations;--货位

SELECT * FROM mtl_lot_numbers;--批次

SELECT * FROM mtl_onhand_quantities;--现有量

SELECT * FROM mtl_serial_numbers;--序号

SELECT * FROM mtl_material_transactions;--物料事务处理

SELECT * FROM mtl_transaction_accounts;

SELECT * FROM mtl_transaction_types;--事务处理类型

SELECT * FROM mtl_txn_source_types;--事务处理类型

SELECT * FROM mtl_supply;--可以接收入库的记录

select * from mfg_lookups;

SELECT * FROM mtl_generic_dispositions;--账户别名

--FND部分表

SELECT * FROM fnd_application;--应用

SELECT * FROM fnd_application_tl;

SELECT * FROM fnd_application_vl;

SELECT * FROM fnd_flex_value_sets;--值集

SELECT * FROM fnd_flex_values;

SELECT * FROM fnd_flex_values_tl;

SELECT * FROM fnd_flex_values_vl;

SELECT * FROM fnd_id_flexs;--弹性域

SELECT * FROM fnd_id_flex_structures;

SELECT * FROM fnd_id_flex_segments;

SELECT * FROM fnd_profile_options_vl;

SELECT * FROM fnd_concurrent_programs;--并发请求

SELECT * FROM fnd_concurrent_requests;

SELECT * FROM fnd_concurrent_processes;

SELECT * FROM fnd_form_vl;--表单

SELECT * FROM fnd_menu_entries;-- 功能-菜单

SELECT * FROM fnd_menus_vl;--菜单

SELECT * FROM fnd_form_custom_rules;

SELECT * FROM fnd_flex_validation_tables;--验证-请求集

SELECT * FROM APPS.FND_MENU_ENTRIES_VL ;--菜单

SELECT * FROM apps.fnd_responsibility;--职责

SELECT * FROM  apps.fnd_responsibility_tl;--职责

--OE销售

select * from ra_customers;-- 客户

select * from ra_addresses_all;-- 地址

select * from ra_site_uses_all;-- 用户

select * from oe_order_headers_all;-- 销售头

select * from oe_order_lines_all;-- 销售行

SELECT * FROM oe_transaction_types_tl;--销售订单类型order_type_id = ott.transaction_type_id

select * from wsh_new_deliveries;-- 发送

select * from wsh_delivery_details;--

select * from wsh_delivery_assignment;--

--示警邮件

SELECT * FROM ALR_ALERTS a