-
call fnd__INITIALIZE(1318,50583,401)
select fnd_('ORG_ID') FROM DUAL
select * from hr_operating_units hou
where zation_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
进程表
--inv
select * from
org_organization_definitions
库存组织
select * from mtl_parameters
组织参数
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
现有量表
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 mfg_lookups ml where _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
发送
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
--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
发送
select * from wsh_delivery_details
select * from wsh_delivery_assignments
--gl
select * from
gl_sets_of_books
总帐
select
*
from
gl_code_combinations
gcc
where
y_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
事务处理
批
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
付款计划
--ap
select * from
ap_invoices_all
发票头
select * from
ap_invoice_distributions_all
发票行
select * from
ap_payment_schedules_all
付款计划
select *
from ap_check_stocks_all
单据
select * from
ap_checks_all
付款
select * from ap_bank_branches
银行
select * from ap_bank_accounts_all
银行帐号
select * from ap_invoice_payments_all
核销
<
/p>
========================
华丽的分割
线
=========================
INV
库存
organization
两个含义
:
1.
< br>经营单位,
A/B/C
分公司,
A
下面有
A1
,
A2
等工厂,主题目标是为了独立核