《oracle应用产品重要表和关系介绍functional_foundation》由会员分享，可在线阅读，更多相关《oracle应用产品重要表和关系介绍functional_foundation（68页珍藏版）》请在金锄头文库上搜索。
1、 张德全 Senior Technical Analyst Oracle Corporation Oracle 应用产品重要表 用途与关系介绍 概要 l了解表的用途及其关系的作用 l主要功能模块表的用途及其关系 l库存(INV),采购(PO),销售(OM) l物料清单(BOM),在制(WIP),成本(COST) l总帐(GL),应收(AR),应付(AP),固定资产(FA) 符号说明 A B A B 一对一相关 多对一相关 必须相关可能相关 库存(INV) 库存(INV) 库存(INV) 库存(INV) Email通知 通知浏览器 应用窗 We 浏览器 工作流引擎 通知系统 Oracle 7.3
2、.2 or higher 工作流监控器 工作流生成 工作流载入器 库存(INV) 库存(INV) 库存(INV) 库存(INV) 库存(INV) 采购(PO) 采购(PO) 采购(PO) 采购(PO) 采购(PO) 采购(PO) 订单管理(OM) OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL 订单管理(OM) WSH_TRIPS WSH_TRIP_STOPS WSH_DELIVERY_LEGS WSH_NEW_DELIVERIES WSH_DELIVERY_ASSIGNMENTS WSH_DELIVERY_DETAILS 订单管理(OM) OE_ORDER_L
3、INES_ALL WSH_DELIVERY_DETAILS MTL_TXN_REQUEST_LINES MTL_MATERIAL_TRANSACTIONS MTL_MATERIAL_TRANSACTIONS_TEMP 物料清单(BOM) 物料清单(BOM) 物料清单(BOM) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 成本(COST) 成本(COST) 成本(COST) 总帐(GL) 总帐(GL) 总帐(GL) 总帐(GL) 应收(AR) 应收(AR) 应收(AR) 应付(AP) 应付(AP)
4、 应付(AP) 固定资产(FA) 固定资产(FA) 固定资产(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_FL
5、EX_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_
6、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_FL
7、EX_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_COM
8、PLEX_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
9、_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
10、_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_CONCUR
11、RENT_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_PROGRA
12、M_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.
