OracleERP各模塊之間表關(guān)系.ppt

1、,張德全,Senior Technical Analyst Oracle Corporation,Oracle 應(yīng)用產(chǎn)品重要表用途與關(guān)系介紹,概要,了解表的用途及其關(guān)系的作用 主要功能模塊表的用途及其關(guān)系 庫存(INV),采購(PO),銷售(OM) 物料清單(BOM),在制(WIP),成本(COST) 總帳(GL),應(yīng)收(AR),應(yīng)付(AP),固定資產(chǎn)(FA),符號(hào)說明,A,B,A,B,一對(duì)一相關(guān),多對(duì)一相關(guān),必須相關(guān),可能相關(guān),庫存(INV),庫存(INV),庫存(INV),庫存(INV),Email通知,通知瀏覽器,應(yīng)用窗,We 瀏覽器,工作流引擎,通知系統(tǒng),Oracle 7.3.2 or

2、 higher,工作流監(jiān)控器,工作流生成,工作流載入器,庫存(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_

3、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),應(yīng)收(AR),應(yīng)收(AR),應(yīng)收(AR),應(yīng)付(AP),應(yīng)付(AP),應(yīng)付(A

4、P),固定資產(chǎn)(FA),固定資產(chǎn)(FA),固定資產(chǎn)(FA),彈性域,表名縮寫對(duì)照表,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_VA

5、LIDATION_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:F

6、ND_APPLICATION FND_TAB:FND_TABLES WF_RPV:WF_RUNNABLE_PROCESSES_V FND_FWP: FND_FLEX_WORKFLOW_PROCESSES,彈性域,彈性域,表名縮寫對(duì)照表,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_VA

7、LUES 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,并發(fā)管理器,FND_CCR:FND_CONCURRENT_COMPLEX_RULES FND_CCL:FND_CONCURRENT_COMPLEX_

8、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_PARA

9、MS 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,并發(fā)處理,表名縮寫對(duì)照表,FND_CPA:FND_CONC_PP_ACTIONS FND_CRA:FND_CONC_REQUEST_ARGUMENTS FND_RRL:FND_RUN_REQ_LANG

10、UAGES 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_

11、PROGRAM-SERIAL FND_CPG: FND_CONCURRENT-PROGRAMS FND_EXE:FND_EXECUTABLES,標(biāo)準(zhǔn)請(qǐng)求,表名縮寫對(duì)照表,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_ARG

12、S FND_RR:FND_RUN_REQUESTS FND_DF:FND-DESCRIPTIVE_FLEXS FND_CPG:FND_CONCURRENT_PROGRAMS FND_RES:FND_RESPONSIBILITY FND_APP:FND_APPLICATION,功能安全,登錄安全,表名縮寫對(duì)照表,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_