oracle-erp各模块表关系PPT.ppt

Body Text,Second Level,Third Level,Fourth Level,Fifth Level,Click to edit Master title style,张德全,Senior Technical Analyst,Oracle Corporation,Oracle,应用产品重要表用途与关系介绍,概要,了解表的用途及其关系的作用,主要功能模块表的用途及其关系,库存,(INV),采购,(PO),销售,(OM),物料清单,(BOM),在制,(WIP),成本,(COST),总帐,(GL),应收,(AR),应付,(AP),固定资产,(FA),符号说明,A,B,A,B,一对一相关,多对一相关,必须相关,可能相关,库存,(INV),库存,(INV),库存,(INV),库存,(INV),Email,通知,通知浏览器,应用窗,We,浏览器,工作流引擎,通知系统,Oracle 7.3.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_LINES_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),应付,(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_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.,