oracle schedular 参数,ORACLE 内部数据结构.ppt

ORACLE 内部数据结构

* MTL_MATERIAL_TXN_ALLOCATIONS MTL_MATERIAL_TXN_ALLOCATIONS stores the repetitive schedules charged by a material transaction. Each row contains the quantity transacted to each schedule for a given transaction. Oracle Work in Process uses this information to report changes to individual schedules for multischedule material transactions. the Primary key is TRANSACTION_ID,REPETITIVE_SCHEDULE_ID, ORGANIZATION_ID. * CST_ITEM_COSTS CST_ITEM_COSTS stores the cost control information. The Define Item Cost window inserts information into this table. The primary key is INVENTORY_ITEM_ID, ORGANIZATION_ID, COST_TYPE_ID. CST_ITEM_COST_DETAILS CST_ITEM_COST_DETAILS stores detailed cost information for an item for a cost type. It is the child table of CST_ITEM_COSTS. The primary key is INVENTORY_ITEM_ID, ORGANIZATION_ID, COST_TYPE_ID. * CST_QUANTITY_LAYERS CST_QUANTITY_LAYERS stores item average cost, FIFO, and LIFO information by cost layer. This table is only used for average costing, FIFO, and LIFO organizations. The primary key is LAYER_ID. CST_LAYER_COST_DETAILS CST_LAYER_COST_DETAILS stores detailed cost information by element and level. It is a child table of CST_QUANTITY_LAYERS. The primary key is LAYER_ID, COST_ELEMENT_ID, LEVEL_TYPE. * CST_RESOURCE_COSTS CST_RESOURCE_COSTS stores resource and outside processing resource unit costs by a cost type. The primary key is RESOURCE_ID, COST_TYPE_ID. CST_RESOURCE_OVERHEADS CST_RESOURCE_OVERHEADS stores the list of resources to which an overhead applies. The cost processor looks at this table to find the overheads that need to be absorbed. The primary key is COST_TYPE_ID,RESOURCE_ID, OVERHEAD_ID. WIP_REQ_OPERATION_COST_DETAILS WIP_REQ_OPERATION_COST_DETAILS stores material costs earned by and relieved from a job in an average costing organization. This table is a child table of WIP_REQUIREMENT_OPERATIONS. This table stores applied and relieved material costs by cost element for each row in WIP_REQUIREMENT_OPERATIONS. * GL_B