--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 |
|