VIEW: ENG.ENG_REVISED_ITEMS_INTERFACE#

Source

View Text - Preformatted

select CHANGE_NOTICE CHANGE_NOTICE, ORGANIZATION_ID ORGANIZATION_ID, REVISED_ITEM_ID REVISED_ITEM_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IMPLEMENTATION_DATE IMPLEMENTATION_DATE, DESCRIPTIVE_TEXT DESCRIPTIVE_TEXT, CANCELLATION_DATE CANCELLATION_DATE, CANCEL_COMMENTS CANCEL_COMMENTS, DISPOSITION_TYPE DISPOSITION_TYPE, NEW_ITEM_REVISION NEW_ITEM_REVISION, AUTO_IMPLEMENT_DATE AUTO_IMPLEMENT_DATE, EARLY_SCHEDULE_DATE EARLY_SCHEDULE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, STATUS_TYPE STATUS_TYPE, SCHEDULED_DATE SCHEDULED_DATE, BILL_SEQUENCE_ID BILL_SEQUENCE_ID, MRP_ACTIVE MRP_ACTIVE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, UPDATE_WIP UPDATE_WIP, USE_UP USE_UP, USE_UP_ITEM_ID USE_UP_ITEM_ID, REVISED_ITEM_SEQUENCE_ID REVISED_ITEM_SEQUENCE_ID, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, CATEGORY_SET_ID CATEGORY_SET_ID, STRUCTURE_ID STRUCTURE_ID, ITEM_FROM ITEM_FROM, ITEM_TO ITEM_TO, CATEGORY_FROM CATEGORY_FROM, CATEGORY_TO CATEGORY_TO, DDF_CONTEXT DDF_CONTEXT, INCREMENT_REV INCREMENT_REV, ITEM_TYPE ITEM_TYPE, USE_UP_PLAN_NAME USE_UP_PLAN_NAME, ALTERNATE_SELECTION_CODE ALTERNATE_SELECTION_CODE, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_TYPE TRANSACTION_TYPE, PROCESS_FLAG PROCESS_FLAG, ORGANIZATION_CODE ORGANIZATION_CODE, REQUESTOR_ID REQUESTOR_ID, COMMENTS COMMENTS, REVISED_ITEM_NUMBER REVISED_ITEM_NUMBER, ASSEMBLY_ITEM_NUMBER ASSEMBLY_ITEM_NUMBER, USE_UP_ITEM_NUMBER USE_UP_ITEM_NUMBER, APPROVAL_LIST_NAME APPROVAL_LIST_NAME, BASE_ITEM_ID BASE_ITEM_ID, ENG_REVISED_ITEMS_IFCE_KEY ENG_REVISED_ITEMS_IFCE_KEY, ENG_CHANGES_IFCE_KEY ENG_CHANGES_IFCE_KEY, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER, NEW_RTG_REVISION NEW_RTG_REVISION, FROM_END_ITEM_REV_ID FROM_END_ITEM_REV_ID, FROM_END_ITEM_NUMBER FROM_END_ITEM_NUMBER, FROM_END_ITEM_REVISION FROM_END_ITEM_REVISION, PARENT_REVISED_ITEM_NAME PARENT_REVISED_ITEM_NAME, PARENT_ALTERNATE_NAME PARENT_ALTERNATE_NAME, UPDATED_ITEM_REVISION UPDATED_ITEM_REVISION, NEW_SCHEDULED_DATE NEW_SCHEDULED_DATE, FROM_ITEM_REVISION FROM_ITEM_REVISION, NEW_REVISION_LABEL NEW_REVISION_LABEL, NEW_REVISED_ITEM_REV_DESC NEW_REVISED_ITEM_REV_DESC, NEW_REVISION_REASON NEW_REVISION_REASON from "ENG"."ENG_REVISED_ITEMS_INTERFACE"

View Text - HTML Formatted

SELECT CHANGE_NOTICE CHANGE_NOTICE
, ORGANIZATION_ID ORGANIZATION_ID
, REVISED_ITEM_ID REVISED_ITEM_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, DESCRIPTIVE_TEXT DESCRIPTIVE_TEXT
, CANCELLATION_DATE CANCELLATION_DATE
, CANCEL_COMMENTS CANCEL_COMMENTS
, DISPOSITION_TYPE DISPOSITION_TYPE
, NEW_ITEM_REVISION NEW_ITEM_REVISION
, AUTO_IMPLEMENT_DATE AUTO_IMPLEMENT_DATE
, EARLY_SCHEDULE_DATE EARLY_SCHEDULE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, STATUS_TYPE STATUS_TYPE
, SCHEDULED_DATE SCHEDULED_DATE
, BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, MRP_ACTIVE MRP_ACTIVE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, UPDATE_WIP UPDATE_WIP
, USE_UP USE_UP
, USE_UP_ITEM_ID USE_UP_ITEM_ID
, REVISED_ITEM_SEQUENCE_ID REVISED_ITEM_SEQUENCE_ID
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, CATEGORY_SET_ID CATEGORY_SET_ID
, STRUCTURE_ID STRUCTURE_ID
, ITEM_FROM ITEM_FROM
, ITEM_TO ITEM_TO
, CATEGORY_FROM CATEGORY_FROM
, CATEGORY_TO CATEGORY_TO
, DDF_CONTEXT DDF_CONTEXT
, INCREMENT_REV INCREMENT_REV
, ITEM_TYPE ITEM_TYPE
, USE_UP_PLAN_NAME USE_UP_PLAN_NAME
, ALTERNATE_SELECTION_CODE ALTERNATE_SELECTION_CODE
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, PROCESS_FLAG PROCESS_FLAG
, ORGANIZATION_CODE ORGANIZATION_CODE
, REQUESTOR_ID REQUESTOR_ID
, COMMENTS COMMENTS
, REVISED_ITEM_NUMBER REVISED_ITEM_NUMBER
, ASSEMBLY_ITEM_NUMBER ASSEMBLY_ITEM_NUMBER
, USE_UP_ITEM_NUMBER USE_UP_ITEM_NUMBER
, APPROVAL_LIST_NAME APPROVAL_LIST_NAME
, BASE_ITEM_ID BASE_ITEM_ID
, ENG_REVISED_ITEMS_IFCE_KEY ENG_REVISED_ITEMS_IFCE_KEY
, ENG_CHANGES_IFCE_KEY ENG_CHANGES_IFCE_KEY
, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, NEW_RTG_REVISION NEW_RTG_REVISION
, FROM_END_ITEM_REV_ID FROM_END_ITEM_REV_ID
, FROM_END_ITEM_NUMBER FROM_END_ITEM_NUMBER
, FROM_END_ITEM_REVISION FROM_END_ITEM_REVISION
, PARENT_REVISED_ITEM_NAME PARENT_REVISED_ITEM_NAME
, PARENT_ALTERNATE_NAME PARENT_ALTERNATE_NAME
, UPDATED_ITEM_REVISION UPDATED_ITEM_REVISION
, NEW_SCHEDULED_DATE NEW_SCHEDULED_DATE
, FROM_ITEM_REVISION FROM_ITEM_REVISION
, NEW_REVISION_LABEL NEW_REVISION_LABEL
, NEW_REVISED_ITEM_REV_DESC NEW_REVISED_ITEM_REV_DESC
, NEW_REVISION_REASON NEW_REVISION_REASON
FROM "ENG"."ENG_REVISED_ITEMS_INTERFACE"