张德全

张德全Senior Technical AnalystOracle Corporation

Oracle 应用产品重要表用途与关系介绍

概要

了解表的用途及其关系的作用主要功能模块表的用途及其关系

库存 (INV),采购 (PO),销售 (OM) 物料清单 (BOM),在制 (WIP),成本 (COST) 总帐 (GL),应收 (AR),应付 (AP),固定资产 (FA)

符号说明

A B

A B

一对一相关

多对一相关

必须相关可能相关

库存 (INV)

库存 (INV)

Email通知

通知浏览器

应用窗

We 浏览器

工作流引擎

通知系统

Oracle 7.3.2 or higher

工作流监控器

工作流生成

工作流载入器

库存 (INV)

采购 (PO)

订单管理 (OM)

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

订单管理 (OM)

WSH_TRIPS

WSH_TRIP_STOPS

WSH_DELIVERY_LEGS

WSH_NEW_DELIVERIESWSH_DELIVERY_ASSIGNMENTS

WSH_DELIVERY_DETAILS

订单管理 (OM)

OE_ORDER_LINES_ALL

WSH_DELIVERY_DETAILS

MTL_TXN_REQUEST_LINES

MTL_MATERIAL_TRANSACTIONS

MTL_MATERIAL_TRANSACTIONS_TEMP

物料清单 (BOM)

在制品 (WIP)

成本 (COST)

总帐 (GL)

应收 (AR)

应付 (AP)

固定资产 (FA)

弹性域

表名缩写对照表FND_IFS: FND_ID_FLEX_SEGMENTS FND_SAV:FND_SEGMENT_ATTRIBUTE_VALUES

FND_SFA:FND_SHORTHAND_FLEX_ALIASES FND_IFSTR:FND_ID_FLEX_STRUCTURE

FND_FVS:FND_FLEX_VALUE_SETS FND_FVRS:FND_FLEX_VALIDATION_RULE_STATS

FND_FERL:FND_FLEX_EXCLUDE_RULE_LINES FND_FVR:FND_FLEX_VALIDATION_RULES

FND_FVQ: FND_FLEX_VALIDATION_QUALIFIERS FND_FVRL: FND_FLEX_VALIDATION_RULE_LINES FND_VAT:FND_VALUE_ATTRIBUTE_TYPES FND_FIRL:FND_FLEX_INCLUDE_RULE_LINES FND_CIFS:FND_COMPILED_ID_FLEX_STRUCTS FND_SAT:FND_SEGMENT_ATTRIBUTE_TYPES FND_CIF:FND_COMPILED_ID_FLEXS FND_IF:FND_ID_FLEXS

FND_APP:FND_APPLICATION FND_TAB:FND_TABLES

WF_RPV:WF_RUNNABLE_PROCESSES_V FND_FWP: FND_FLEX_WORKFLOW_PROCESSES

弹性域

表名缩写对照表FND_FVH: FND_FLEX_VALUE_HIERARCHIES FND_FVS: FND_FLEX_VALUE_SETS

FND_IFS: FND_ID_FLEX_SEGMENTS FND_FVNH: FND_FLEX_VALUE_NORM_HIERARCHY

FND_FH:FND_FLEX_HIERARCHIES FND_FV: FND_FLEX_VALUES

FND_FVE: FND_FLEX_VALIDATION_EVENTS FND_FVRL: FND_FLEX_VALUE_RULE_LINES

FND_FVR: FND_FLEX_VALUE_RULES FND_FVRU: FND_FLEX_VALUE_RULE_USAGES

FND_RESP:FND_RESPONSIBILITY FND_TAB:FND_TABLES

FND_FVT:FND_FLEX_VALIDATION_TABLES

并发管理器

并发管理器FND_CCR:FND_CONCURRENT_COMPLEX_RULES FND_CCL:FND_CONCURRENT_COMPLEX_LINES

FND_CPG: FND_CONCURRENT_PROGRAMS FND_CRC: FND_CONCURRENT_REQUEST_CLASS

FND_OID:FND_ORACLE_USERID FND_USER:FND_USER

FND_CGC: FND_CONCURRENT_QUEUE_CONTENT FND_CR: FND_CONCURRENT_REQUESTS

FND_NDS:FND_NODES FND_CPR: FND_CONCURRENT_PROCESSES

FND_DG:FND_DATA_GROUPS FND_CQP: FND_CONCURRENT_QUEUE_PARAMS

FND_CQ: FND_CONCURRENT_QUEUES FND_CPP:FND_CONC_PROCESSOR_PROGRAMS

FND_CPS: FND_CONCURRENT_PROCESSORS FND_CQS: FND_CONCURRENT_QUEUE_SIZE

FND_CTP: FND_CONCURRENT_TIME_PERIODS FND_APP:FND_APPLICATION

并发处理

表名缩写对照表FND_CPA:FND_CONC_PP_ACTIONS FND_CRA:FND_CONC_REQUEST_ARGUMENTS

FND_RRL:FND_RUN_REQ_LANGUAGES FND_CR: FND_CONCURRENT_REQUESTS

FND_CD:FND_CONFLICT_DOMAINS FND_RES:FND_RESPONSIBILY

FND_CRC:FND_CONC_RELEASE_CLASSES FND_DGU:FND_DATA_GROUP_UNITS

FND_LOG:FND_LOGINS FND_DG:FND_DATA_GROUPS

FND_OID:FND_ORACLE_USERID FND_USR:FND_USER

FND_CRC: FND_CONCURRENT_REQUEST_CLASS FND_CPS: FND_CONCURRENT_PROGRAM-SERIAL

FND_CPG: FND_CONCURRENT-PROGRAMS FND_EXE:FND_EXECUTABLES

标准请求

表名缩写对照表FND_RGU:FND_REQUEST_GROUP_UNITS FND_RS:FND_REQUEST_SETS

FND_RSS:FND_REQUEST_SET_STAGES FND_RRA:FND_RUN_REQ_PP_ACTIONS

FND_RG: FND_REQUEST_GROUPS FND_RSP: FND_REQUEST_SET_PROGRAMS

FND_RSA: FND_REQUEST_SET_PROGRAM_ARGS FND_RR:FND_RUN_REQUESTS

FND_DF:FND-DESCRIPTIVE_FLEXS FND_CPG:FND_CONCURRENT_PROGRAMS

FND_RES:FND_RESPONSIBILITY FND_APP:FND_APPLICATION

功能安全

登录安全

表名缩写对照表FND_URG:FND_USER_RESP_GROUPS FND_RES:FND_RESPONSIBILITY

FND_SG:FND_SECURITY_GROUPS FND_APP:FND_APPLICATION

FND_DGU:FND_DATA_GROUP_UNITS FND_AS:FND_APPLICATION_SERVERS

FND_OID:FND_ORACLE_USERID FND_DG:FND_DATA_GROUPS

FND_SESS:FND_SESSIONS FND_LRF:FND_LOGIN_RESP_FORMS

FND_LR:FND_LOGIN_RESPONSIBILITIES FND_LOG:FND_LOGINS

FND_UL:FND_UNSUCCESSFUL_LOGINS FND_USER:FND_USER

预置文件

数据字典

货币与语言

Thank you.

张德全

Documents

Transcript of 张德全