[Home] [Help] [Dependency Information]
Object Name: | ENG_REVISED_ITEMS# |
---|---|
Object Type: | VIEW |
Owner: | ENG |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANGE_NOTICE | VARCHAR2 | (10) | Yes | |
ORGANIZATION_ID | NUMBER | Yes | ||
REVISED_ITEM_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
IMPLEMENTATION_DATE | DATE | |||
DESCRIPTIVE_TEXT | VARCHAR2 | (240) | ||
CANCELLATION_DATE | DATE | |||
CANCEL_COMMENTS | VARCHAR2 | (240) | ||
DISPOSITION_TYPE | NUMBER | Yes | ||
NEW_ITEM_REVISION | VARCHAR2 | (3) | ||
AUTO_IMPLEMENT_DATE | DATE | |||
EARLY_SCHEDULE_DATE | DATE | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
STATUS_TYPE | NUMBER | Yes | ||
SCHEDULED_DATE | DATE | Yes | ||
BILL_SEQUENCE_ID | NUMBER | |||
MRP_ACTIVE | NUMBER | Yes | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
UPDATE_WIP | NUMBER | Yes | ||
USE_UP | NUMBER | Yes | ||
USE_UP_ITEM_ID | NUMBER | |||
REVISED_ITEM_SEQUENCE_ID | NUMBER | Yes | ||
USE_UP_PLAN_NAME | VARCHAR2 | (10) | ||
FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | ||
FROM_WIP_ENTITY_ID | NUMBER | |||
TO_WIP_ENTITY_ID | NUMBER | |||
FROM_CUM_QTY | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (30) | ||
CFM_ROUTING_FLAG | NUMBER | |||
COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | ||
COMPLETION_LOCATOR_ID | NUMBER | |||
MIXED_MODEL_MAP_FLAG | NUMBER | |||
PRIORITY | NUMBER | |||
CTP_FLAG | NUMBER | |||
ROUTING_SEQUENCE_ID | NUMBER | |||
NEW_ROUTING_REVISION | VARCHAR2 | (3) | ||
ROUTING_COMMENT | VARCHAR2 | (240) | ||
ECO_FOR_PRODUCTION | NUMBER | |||
DESIGNATOR_SELECTION_TYPE | NUMBER | |||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | ||
TRANSFER_OR_COPY | VARCHAR2 | (1) | ||
TRANSFER_OR_COPY_ITEM | NUMBER | |||
TRANSFER_OR_COPY_BILL | NUMBER | |||
TRANSFER_OR_COPY_ROUTING | NUMBER | |||
COPY_TO_ITEM | VARCHAR2 | (2000) | ||
COPY_TO_ITEM_DESC | VARCHAR2 | (240) | ||
IMPLEMENTED_ONLY | NUMBER | |||
SELECTION_OPTION | NUMBER | |||
SELECTION_DATE | DATE | |||
SELECTION_UNIT_NUMBER | VARCHAR2 | (30) | ||
CONCATENATED_COPY_SEGMENTS | VARCHAR2 | (2000) | ||
CHANGE_ID | NUMBER | Yes | ||
NEW_ITEM_REVISION_ID | NUMBER | |||
CURRENT_ITEM_REVISION_ID | NUMBER | |||
CURRENT_LIFECYCLE_STATE_ID | NUMBER | |||
NEW_LIFECYCLE_STATE_ID | NUMBER | |||
STATUS_CODE | NUMBER | Yes | ||
FROM_END_ITEM_ID | NUMBER | |||
FROM_END_ITEM_REV_ID | NUMBER | |||
FROM_END_ITEM_STRC_REV_ID | NUMBER | |||
ENABLE_ITEM_IN_LOCAL_ORG | VARCHAR2 | (1) | ||
CREATE_BOM_IN_LOCAL_ORG | VARCHAR2 | (1) | ||
CURRENT_STRUCTURE_REV_ID | NUMBER | |||
NEW_STRUCTURE_REVISION | VARCHAR2 | (80) | ||
PARENT_REVISED_ITEM_SEQ_ID | NUMBER | |||
PLAN_LEVEL | NUMBER | |||
NEW_REVISION_LABEL | VARCHAR2 | (80) | ||
NEW_REVISION_REASON | VARCHAR2 | (30) | ||
NEW_REV_DESCRIPTION | VARCHAR2 | (240) | ||
IMPLEMENTATION_REQ_ID | NUMBER | |||
NEW_ITEM_DESCRIPTION | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_NOTICE
, ORGANIZATION_ID
, REVISED_ITEM_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, IMPLEMENTATION_DATE
, DESCRIPTIVE_TEXT
, CANCELLATION_DATE
, CANCEL_COMMENTS
, DISPOSITION_TYPE
, NEW_ITEM_REVISION
, AUTO_IMPLEMENT_DATE
, EARLY_SCHEDULE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, STATUS_TYPE
, SCHEDULED_DATE
, BILL_SEQUENCE_ID
, MRP_ACTIVE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, UPDATE_WIP
, USE_UP
, USE_UP_ITEM_ID
, REVISED_ITEM_SEQUENCE_ID
, USE_UP_PLAN_NAME
, FROM_END_ITEM_UNIT_NUMBER
, ORIGINAL_SYSTEM_REFERENCE
, FROM_WIP_ENTITY_ID
, TO_WIP_ENTITY_ID
, FROM_CUM_QTY
, LOT_NUMBER
, CFM_ROUTING_FLAG
, COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID
, MIXED_MODEL_MAP_FLAG
, PRIORITY
, CTP_FLAG
, ROUTING_SEQUENCE_ID
, NEW_ROUTING_REVISION
, ROUTING_COMMENT
, ECO_FOR_PRODUCTION
, DESIGNATOR_SELECTION_TYPE
, ALTERNATE_BOM_DESIGNATOR
, TRANSFER_OR_COPY
, TRANSFER_OR_COPY_ITEM
, TRANSFER_OR_COPY_BILL
, TRANSFER_OR_COPY_ROUTING
, COPY_TO_ITEM
, COPY_TO_ITEM_DESC
, IMPLEMENTED_ONLY
, SELECTION_OPTION
, SELECTION_DATE
, SELECTION_UNIT_NUMBER
, CONCATENATED_COPY_SEGMENTS
, CHANGE_ID
, NEW_ITEM_REVISION_ID
, CURRENT_ITEM_REVISION_ID
, CURRENT_LIFECYCLE_STATE_ID
, NEW_LIFECYCLE_STATE_ID
, STATUS_CODE
, FROM_END_ITEM_ID
, FROM_END_ITEM_REV_ID
, FROM_END_ITEM_STRC_REV_ID
, ENABLE_ITEM_IN_LOCAL_ORG
, CREATE_BOM_IN_LOCAL_ORG
, CURRENT_STRUCTURE_REV_ID
, NEW_STRUCTURE_REVISION
, PARENT_REVISED_ITEM_SEQ_ID
, PLAN_LEVEL
, NEW_REVISION_LABEL
, NEW_REVISION_REASON
, NEW_REV_DESCRIPTION
, IMPLEMENTATION_REQ_ID
, NEW_ITEM_DESCRIPTION
FROM ENG.ENG_REVISED_ITEMS#;
|
|
|