View: BOM_COMPONENT_OPERATIONS_V

Product:	BOM - Bills of Material
Description:	View of all component operation
Implementation/DBA Data:	APPS.BOM_COMPONENT_OPERATIONS_V

View Text

SELECT BCO.ROWID ROW_ID
, BCO.COMP_OPERATION_SEQ_ID COMP_OPERATION_SEQ_ID
, BCO.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BCO.OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, BOS.OPERATION_DESCRIPTION OPERATION_DESCRIPTION
, BCO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BCO.LAST_UPDATED_BY LAST_UPDATED_BY
, BCO.CREATION_DATE CREATION_DATE
, BCO.CREATED_BY CREATED_BY
, BCO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BCO.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, BCO.BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, BCO.CONSUMING_OPERATION_FLAG CONSUMING_OPERATION_FLAG
, BCO.CONSUMPTION_QUANTITY CONSUMPTION_QUANTITY
, BCO.SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY
, BCO.SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID
, BCO.WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, BCO.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BCO.ATTRIBUTE1 ATTRIBUTE1
, BCO.ATTRIBUTE2 ATTRIBUTE2
, BCO.ATTRIBUTE3 ATTRIBUTE3
, BCO.ATTRIBUTE4 ATTRIBUTE4
, BCO.ATTRIBUTE5 ATTRIBUTE5
, BCO.ATTRIBUTE6 ATTRIBUTE6
, BCO.ATTRIBUTE7 ATTRIBUTE7
, BCO.ATTRIBUTE8 ATTRIBUTE8
, BCO.ATTRIBUTE9 ATTRIBUTE9
, BCO.ATTRIBUTE10 ATTRIBUTE10
, BCO.ATTRIBUTE11 ATTRIBUTE11
, BCO.ATTRIBUTE12 ATTRIBUTE12
, BCO.ATTRIBUTE13 ATTRIBUTE13
, BCO.ATTRIBUTE14 ATTRIBUTE14
, BCO.ATTRIBUTE15 ATTRIBUTE15
, BCO.COMMON_COMPONENT_SEQUENCE_ID
FROM BOM_COMPONENT_OPERATIONS BCO
, BOM_OPERATION_SEQUENCES BOS
WHERE BCO.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID

Columns