View: ENG_COMPONENT_VIEW

Product:	ENG - Engineering
Description:	This view joins BOM_INVENTORY_COMPONENTS and ENG_REVISED_COMPONENTS to display all revised components for a revised item
Implementation/DBA Data:	APPS.ENG_COMPONENT_VIEW

View Text

SELECT A.COMPONENT_SEQUENCE_ID
, A.COMPONENT_ITEM_ID
, A.BILL_SEQUENCE_ID
, A.CHANGE_NOTICE
, A.EFFECTIVITY_DATE
, A.COMPONENT_QUANTITY
, A.COMPONENT_YIELD_FACTOR
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.CANCELLATION_DATE
, A.CANCEL_COMMENTS
, A.OLD_COMPONENT_SEQUENCE_ID
, A.ITEM_NUM
, A.WIP_SUPPLY_TYPE
, A.COMPONENT_REMARKS
, A.IMPLEMENTATION_DATE
, A.DISABLE_DATE
, A.ACD_TYPE
, A.PLANNING_FACTOR
, A.QUANTITY_RELATED
, A.SO_BASIS
, A.OPTIONAL
, A.MUTUALLY_EXCLUSIVE_OPTIONS
, A.INCLUDE_IN_COST_ROLLUP
, A.CHECK_ATP
, A.SHIPPING_ALLOWED
, A.REQUIRED_TO_SHIP
, A.REQUIRED_FOR_REVENUE
, A.INCLUDE_ON_SHIP_DOCS
, A.INCLUDE_ON_BILL_DOCS
, A.LOW_QUANTITY
, A.HIGH_QUANTITY
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.PICK_COMPONENTS
, A.OPERATION_SEQUENCE_NUM
, A.SUPPLY_SUBINVENTORY
, A.SUPPLY_LOCATOR_ID
, A.REVISED_ITEM_SEQUENCE_ID
, A.COST_FACTOR
FROM ENG_REVISED_COMPONENTS A UNION (SELECT COMPONENT_SEQUENCE_ID
, COMPONENT_ITEM_ID
, BILL_SEQUENCE_ID
, CHANGE_NOTICE
, EFFECTIVITY_DATE
, COMPONENT_QUANTITY
, COMPONENT_YIELD_FACTOR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TO_DATE(''
, 'DD-MON-YY')
, NULL
, OLD_COMPONENT_SEQUENCE_ID
, ITEM_NUM
, WIP_SUPPLY_TYPE
, COMPONENT_REMARKS
, IMPLEMENTATION_DATE
, DISABLE_DATE
, ACD_TYPE
, PLANNING_FACTOR
, QUANTITY_RELATED
, SO_BASIS
, OPTIONAL
, MUTUALLY_EXCLUSIVE_OPTIONS
, INCLUDE_IN_COST_ROLLUP
, CHECK_ATP
, SHIPPING_ALLOWED
, REQUIRED_TO_SHIP
, REQUIRED_FOR_REVENUE
, INCLUDE_ON_SHIP_DOCS
, INCLUDE_ON_BILL_DOCS
, LOW_QUANTITY
, HIGH_QUANTITY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PICK_COMPONENTS
, OPERATION_SEQ_NUM
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, REVISED_ITEM_SEQUENCE_ID
, COST_FACTOR
FROM BOM_INVENTORY_COMPONENTS B
WHERE B.IMPLEMENTATION_DATE IS NULL
AND B.CHANGE_NOTICE IS NOT NULL )

Columns