call fnd_global.APPS_INITIALIZE(1318,50583,401)
select fnd_profile.VALUE('ORG_ID') FROM DUAL
select * from hr_operating_units hou where hou.organization_id=204
--fnd
select * from fnd_application
select * from fnd_application_tl where application_id=101
select * from fnd_application_vl where application_id = 101
----值集
select * from fnd_flex_value_sets
select * from fnd_flex_values
select * from fnd_flex_values_vl
----彈性域
select * from fnd_id_flexs
select * from fnd_id_flex_structures where id_flex_code='GL#'
select * from fnd_id_flex_segments where id_flex_code='GL#' and id_flex_num=50671

select * from fnd_profile_options_vl
select * from fnd_concurrent_programs 程序表
select * from fnd_concurrent_requests 請求表
select * from fnd_concurrent_processes 進(jìn)程表

--inv
select * from org_organization_definitions 庫存組織
select * from mtl_parameters 組織參數(shù)
select * from mtl_system_items_b where inventory_item_id = 171 and organization_id=204 物料表
select * from mtl_secondary_inventories 子庫存
select * from mtl_item_locations 貨位
select * from mtl_lot_numbers 批次
select * from mtl_onhand_quantities 現(xiàn)有量表
select * from mtl_serial_numbers 序列
select * from mtl_material_transactions 物料事務(wù)記錄
select * from mtl_transaction_accounts 會計(jì)分錄
select * from mtl_transaction_types 事務(wù)類型
select * from mtl_txn_source_types 事務(wù)來源類型
select * from mfg_lookups ml where ml.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION'

--po
select * from po_requisition_headers_all 請求頭
select * from po_requisition_lines_all 請求行
select * from po_headers_all 訂單頭
select * from po_lines_all 訂單行
select * from po_line_locations_all
select * from po_distributions_all 分配
select * from po_releases_all 發(fā)送
select * from rcv_shipment_headers 采購接收頭
select * from rcv_shipment_lines 采購接收行
select * from rcv_transactions 接收事務(wù)處理
select * from po_agents
select * from po_vendors 訂單
select * from po_vendor_sites_all

--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 wsh_new_deliveries 發(fā)送
select * from wsh_delivery_details
select * from wsh_delivery_assignments

--gl
select * from gl_sets_of_books 總帳
select * from gl_code_combinations gcc where gcc.summary_flag='Y' 科目組合
select * from gl_balances 科目余額
select * from gl_je_batches 憑證批
select * from gl_je_headers 憑證頭
select * from gl_je_lines 憑證行
select * from gl_je_categories 憑證分類
select * from gl_je_sources 憑證來源
select * from gl_summary_templates 科目匯總模板
select * from gl_account_hierarchies 科目匯總模板層次

--ar
select * from ar_batches_all 事務(wù)處理批
select * from ra_customer_trx_all 發(fā)票頭
select * from ra_customer_trx_lines_all 發(fā)票行
select * from ra_cust_trx_line_gl_dist_all 發(fā)票分配
select * from ar_cash_receipts_all 收款
select * from ar_receivable_applications_all 核銷
select * from ar_payment_schedules_all 發(fā)票調(diào)整
select * from ar_adjustments_all 會計(jì)分錄
select * from ar_distributions_all 付款計(jì)劃

--ap
select * from ap_invoices_all 發(fā)票頭
select * from ap_invoice_distributions_all 發(fā)票行
select * from ap_payment_schedules_all 付款計(jì)劃
select * from ap_check_stocks_all 單據(jù)
select * from ap_checks_all 付款
select * from ap_bank_branches 銀行
select * from ap_bank_accounts_all 銀行帳號
select * from ap_invoice_payments_all 核銷