表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
- OPERATION_SEQUENCE_ID
Primary Key: BOM_OPERATION_SEQUENCES_UK1
ROUTING_SEQUENCE_ID
OPERATION_SEQ_NUM
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/207/viewspace-780032/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/207/viewspace-780032/