VIEW: APPS.ENG_COMPONENT_VIEW

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )