VIEW: ENG.ENG_REVISED_ITEMS#

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, USE_UP_PLAN_NAME USE_UP_PLAN_NAME, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, FROM_WIP_ENTITY_ID FROM_WIP_ENTITY_ID, TO_WIP_ENTITY_ID TO_WIP_ENTITY_ID, FROM_CUM_QTY FROM_CUM_QTY, LOT_NUMBER LOT_NUMBER, CFM_ROUTING_FLAG CFM_ROUTING_FLAG, COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY, COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID, MIXED_MODEL_MAP_FLAG MIXED_MODEL_MAP_FLAG, PRIORITY PRIORITY, CTP_FLAG CTP_FLAG, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, NEW_ROUTING_REVISION NEW_ROUTING_REVISION, ROUTING_COMMENT ROUTING_COMMENT, ECO_FOR_PRODUCTION ECO_FOR_PRODUCTION, DESIGNATOR_SELECTION_TYPE DESIGNATOR_SELECTION_TYPE, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, TRANSFER_OR_COPY TRANSFER_OR_COPY, TRANSFER_OR_COPY_ITEM TRANSFER_OR_COPY_ITEM, TRANSFER_OR_COPY_BILL TRANSFER_OR_COPY_BILL, TRANSFER_OR_COPY_ROUTING TRANSFER_OR_COPY_ROUTING, COPY_TO_ITEM COPY_TO_ITEM, COPY_TO_ITEM_DESC COPY_TO_ITEM_DESC, IMPLEMENTED_ONLY IMPLEMENTED_ONLY, SELECTION_OPTION SELECTION_OPTION, SELECTION_DATE SELECTION_DATE, SELECTION_UNIT_NUMBER SELECTION_UNIT_NUMBER, CONCATENATED_COPY_SEGMENTS CONCATENATED_COPY_SEGMENTS, CHANGE_ID CHANGE_ID, NEW_ITEM_REVISION_ID NEW_ITEM_REVISION_ID, CURRENT_ITEM_REVISION_ID CURRENT_ITEM_REVISION_ID, CURRENT_LIFECYCLE_STATE_ID CURRENT_LIFECYCLE_STATE_ID, NEW_LIFECYCLE_STATE_ID NEW_LIFECYCLE_STATE_ID, STATUS_CODE STATUS_CODE, FROM_END_ITEM_ID FROM_END_ITEM_ID, FROM_END_ITEM_REV_ID FROM_END_ITEM_REV_ID, FROM_END_ITEM_STRC_REV_ID FROM_END_ITEM_STRC_REV_ID, ENABLE_ITEM_IN_LOCAL_ORG ENABLE_ITEM_IN_LOCAL_ORG, CREATE_BOM_IN_LOCAL_ORG CREATE_BOM_IN_LOCAL_ORG, CURRENT_STRUCTURE_REV_ID CURRENT_STRUCTURE_REV_ID, NEW_STRUCTURE_REVISION NEW_STRUCTURE_REVISION, PARENT_REVISED_ITEM_SEQ_ID PARENT_REVISED_ITEM_SEQ_ID, PLAN_LEVEL PLAN_LEVEL, NEW_REVISION_LABEL NEW_REVISION_LABEL, NEW_REVISION_REASON NEW_REVISION_REASON, NEW_REV_DESCRIPTION NEW_REV_DESCRIPTION, IMPLEMENTATION_REQ_ID IMPLEMENTATION_REQ_ID, NEW_ITEM_DESCRIPTION NEW_ITEM_DESCRIPTION from "ENG"."ENG_REVISED_ITEMS"

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
, USE_UP_PLAN_NAME USE_UP_PLAN_NAME
, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, FROM_WIP_ENTITY_ID FROM_WIP_ENTITY_ID
, TO_WIP_ENTITY_ID TO_WIP_ENTITY_ID
, FROM_CUM_QTY FROM_CUM_QTY
, LOT_NUMBER LOT_NUMBER
, CFM_ROUTING_FLAG CFM_ROUTING_FLAG
, COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID
, MIXED_MODEL_MAP_FLAG MIXED_MODEL_MAP_FLAG
, PRIORITY PRIORITY
, CTP_FLAG CTP_FLAG
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, NEW_ROUTING_REVISION NEW_ROUTING_REVISION
, ROUTING_COMMENT ROUTING_COMMENT
, ECO_FOR_PRODUCTION ECO_FOR_PRODUCTION
, DESIGNATOR_SELECTION_TYPE DESIGNATOR_SELECTION_TYPE
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, TRANSFER_OR_COPY TRANSFER_OR_COPY
, TRANSFER_OR_COPY_ITEM TRANSFER_OR_COPY_ITEM
, TRANSFER_OR_COPY_BILL TRANSFER_OR_COPY_BILL
, TRANSFER_OR_COPY_ROUTING TRANSFER_OR_COPY_ROUTING
, COPY_TO_ITEM COPY_TO_ITEM
, COPY_TO_ITEM_DESC COPY_TO_ITEM_DESC
, IMPLEMENTED_ONLY IMPLEMENTED_ONLY
, SELECTION_OPTION SELECTION_OPTION
, SELECTION_DATE SELECTION_DATE
, SELECTION_UNIT_NUMBER SELECTION_UNIT_NUMBER
, CONCATENATED_COPY_SEGMENTS CONCATENATED_COPY_SEGMENTS
, CHANGE_ID CHANGE_ID
, NEW_ITEM_REVISION_ID NEW_ITEM_REVISION_ID
, CURRENT_ITEM_REVISION_ID CURRENT_ITEM_REVISION_ID
, CURRENT_LIFECYCLE_STATE_ID CURRENT_LIFECYCLE_STATE_ID
, NEW_LIFECYCLE_STATE_ID NEW_LIFECYCLE_STATE_ID
, STATUS_CODE STATUS_CODE
, FROM_END_ITEM_ID FROM_END_ITEM_ID
, FROM_END_ITEM_REV_ID FROM_END_ITEM_REV_ID
, FROM_END_ITEM_STRC_REV_ID FROM_END_ITEM_STRC_REV_ID
, ENABLE_ITEM_IN_LOCAL_ORG ENABLE_ITEM_IN_LOCAL_ORG
, CREATE_BOM_IN_LOCAL_ORG CREATE_BOM_IN_LOCAL_ORG
, CURRENT_STRUCTURE_REV_ID CURRENT_STRUCTURE_REV_ID
, NEW_STRUCTURE_REVISION NEW_STRUCTURE_REVISION
, PARENT_REVISED_ITEM_SEQ_ID PARENT_REVISED_ITEM_SEQ_ID
, PLAN_LEVEL PLAN_LEVEL
, NEW_REVISION_LABEL NEW_REVISION_LABEL
, NEW_REVISION_REASON NEW_REVISION_REASON
, NEW_REV_DESCRIPTION NEW_REV_DESCRIPTION
, IMPLEMENTATION_REQ_ID IMPLEMENTATION_REQ_ID
, NEW_ITEM_DESCRIPTION NEW_ITEM_DESCRIPTION
FROM "ENG"."ENG_REVISED_ITEMS"