View: BOM_COMPONENT_ALL_OPERATIONS_V

Product:	BOM - Bills of Material
Description:	View of all operation for components - all records
Implementation/DBA Data:	APPS.BOM_COMPONENT_ALL_OPERATIONS_V

View Text

SELECT BIC.BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, BIC.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, BIC.COMPONENT_ITEM_ID COMPONENT_ITEM_ID
, BIC.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BIC.EFFECTIVITY_DATE EFFECTIVITY_DATE
, BIC.DISABLE_DATE DISABLE_DATE
, BIC.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, BIC.TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
, BIC.IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, BIC.ECO_FOR_PRODUCTION ECO_FOR_PRODUCTION
, 0 COMP_OPERATION_SEQ_ID
, BIC.ROWID ROW_ID
, 'COMPONENT' ENTITY_IDENTIFIER
FROM BOM_INVENTORY_COMPONENTS BIC UNION SELECT BCO.BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, BCO.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, BIC.COMPONENT_ITEM_ID COMPONENT_ITEM_ID
, BCO.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BIC.EFFECTIVITY_DATE EFFECTIVITY_DATE
, BIC.DISABLE_DATE DISABLE_DATE
, BIC.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, BIC.TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
, BIC.IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, BIC.ECO_FOR_PRODUCTION ECO_FOR_PRODUCTION
, BCO.COMP_OPERATION_SEQ_ID COMP_OPERATION_SEQ_ID
, BCO.ROWID ROW_ID
, 'OPERATION' ENTITY_IDENTIFIER
FROM BOM_COMPONENT_OPERATIONS BCO
, BOM_INVENTORY_COMPONENTS BIC
WHERE BCO.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID

Columns