Oracle App 培訓筆記(8) -- 成本管理模組表結構整理 續

表9. BOM.BOM_OPERATION_SEQUENCES

[@more@]

 

9.    TABLE: BOM.BOM_OPERATION_SEQUENCES

BOM_OPERATION_SEQUENCES stores information about routing operations.
You may define multiple operations for a routing. You must specify
the department in which every operation will occur.
.
Oracle Bills of Material stores the STANDARD_OPERATION_ID if you use
a standard operation to define your operation.
.
You cannot have overlapping effective dates for the same operation.
The Define Routing window will prevent you from doing that. For
example, you cannot define operations as follows:

Primary Key: BOM_OPERATION_SEQUENCES_PK

1. OPERATION_SEQUENCE_ID

Primary Key: BOM_OPERATION_SEQUENCES_UK1

1. ROUTING_SEQUENCE_ID

2. OPERATION_SEQ_NUM

3. EFFECTIVITY_DATE

Columns

OPERATION_SEQUENCE_ID	NUMBER		Yes	Routing operation unique identifier
ROUTING_SEQUENCE_ID	NUMBER		Yes	Routing unique identifier
OPERATION_SEQ_NUM	NUMBER		Yes	Operation sequence number
STANDARD_OPERATION_ID	NUMBER			Standard operation unique identifier
DEPARTMENT_ID	NUMBER		Yes	Department unique identifier
OPERATION_LEAD_TIME_PERCENT	NUMBER			Indicates the amount of overlap its lead time has with the parent's lead time
MINIMUM_TRANSFER_QUANTITY	NUMBER			Minimum operation transfer quantity
COUNT_POINT_TYPE	NUMBER		Yes	Count point
OPERATION_DESCRIPTION	VARCHAR2	(240)		Description of operation
EFFECTIVITY_DATE	DATE		Yes	Date operation is effective
DISABLE_DATE	DATE			Date operation is no longer effective - effectivity lasts until the end of the disable date
BACKFLUSH_FLAG	NUMBER		Yes	Indicates whether operation requires backflushing
OPTION_DEPENDENT_FLAG	NUMBER		Yes	Indicates whether to use this operation in all configuration

 

10.    Some SQLs

 

SELECT   cic.ORGANIZATION_ID,
         cic.INVENTORY_ITEM_ID,
         cic.COST_TYPE_ID,
         cct.COST_TYPE,
         cic.item_cost,
         cce.COST_ELEMENT_ID,
         cce.COST_ELEMENT,
         cce.DESCRIPTION
FROM     CST_COST_TYPES cct,
         CST_ITEM_COST_DETAILS cic,
         CST_COST_ELEMENTS cce
WHERE    cct.COST_TYPE_ID = cic.COST_TYPE_ID
AND      cic.COST_ELEMENT_ID = cce.COST_ELEMENT_ID
AND      cic.organization_id=207
AND      cic.inventory_item_id=556
AND      cic.cost_type_id=1