[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ENG_REVISED_ITEMS |
|---|---|
| Object Type: | TABLE |
| Owner: | ENG |
| FND Design Data: |  ENG.ENG_REVISED_ITEMS
|
| Subobject Name: | |
| Status: | VALID |
ENG_REVISED_ITEMS stores information about the revised items on an
engineering change order. It is a child table of
ENG_ENGINEERING_CHANGES. Since each ECO may have more than one
revised item that refers to the same bill, the column
REVISED_ITEM_SEQUENCE_ID is used to differentiate between multiple
occurences of the same item on an ECO.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 20 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ENG_REVISED_ITEMS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REVISED_ITEM_SEQUENCE_ID
|
| ENG_REVISED_ITEMS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
CHANGE_NOTICE
REVISED_ITEM_ID
|
| ENG_REVISED_ITEMS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BILL_SEQUENCE_ID
NEW_ITEM_REVISION
CHANGE_ID
|
| ENG_REVISED_ITEMS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
USE_UP_ITEM_ID
|
| ENG_REVISED_ITEMS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REVISED_ITEM_ID
ORGANIZATION_ID
|
| ENG_REVISED_ITEMS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
REVISED_ITEM_ID
CHANGE_NOTICE
SCHEDULED_DATE
FROM_END_ITEM_UNIT_NUMBER
NEW_ROUTING_REVISION
|
| ENG_REVISED_ITEMS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
REVISED_ITEM_ID
CHANGE_NOTICE
NEW_ITEM_REVISION
SCHEDULED_DATE
FROM_END_ITEM_UNIT_NUMBER
|
| ENG_REVISED_ITEMS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CHANGE_ID
|
| ENG_REVISED_ITEMS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REVISED_ITEM_ID
CHANGE_ID
|
| ENG_REVISED_ITEMS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BILL_SEQUENCE_ID
CHANGE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CHANGE_NOTICE | VARCHAR2 | (10) | Yes | Engineering change order number |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| REVISED_ITEM_ID | NUMBER | Yes | Revised item identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| IMPLEMENTATION_DATE | DATE | Implementation date of the revised item | ||
| DESCRIPTIVE_TEXT | VARCHAR2 | (240) | Descriptive text | |
| CANCELLATION_DATE | DATE | Cancellation date of the revised item | ||
| CANCEL_COMMENTS | VARCHAR2 | (240) | Cancellation comments | |
| DISPOSITION_TYPE | NUMBER | Yes | Disposition type (information purposes only) | |
| NEW_ITEM_REVISION | VARCHAR2 | (3) | New revision of the revised item | |
| AUTO_IMPLEMENT_DATE | DATE | Date that the revised item was scheduled for auto implementation | ||
| EARLY_SCHEDULE_DATE | DATE | Early effective date | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| STATUS_TYPE | NUMBER | Yes | Status of the revised item | |
| SCHEDULED_DATE | DATE | Yes | Effective date of the revised item | |
| BILL_SEQUENCE_ID | NUMBER | Bill of material unique identifier | ||
| MRP_ACTIVE | NUMBER | Yes | Flag indicating whether the revised item is available to MRP | |
| REQUEST_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| UPDATE_WIP | NUMBER | Yes | Flag indicating whether or not to update repetitive schedules and unreleased discrete jobs in WIP when the revised item is implemented | |
| USE_UP | NUMBER | Yes | Flag indicating whether or not the use up date for an item is being used as the effective date for the revised item | |
| USE_UP_ITEM_ID | NUMBER | Identifier of the use up item | ||
| REVISED_ITEM_SEQUENCE_ID | NUMBER | Yes | Unique identifier of a revised item | |
| USE_UP_PLAN_NAME | VARCHAR2 | (10) | Use up plan name | |
| FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | From End Item Unit Number | |
| ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original system that data for the current record has come from | |
| FROM_WIP_ENTITY_ID | NUMBER | From WIP Enity Id | ||
| TO_WIP_ENTITY_ID | NUMBER | To WIP Entity Id | ||
| FROM_CUM_QTY | NUMBER | From CUM Qty | ||
| LOT_NUMBER | VARCHAR2 | (30) | Lot Number | |
| CFM_ROUTING_FLAG | NUMBER | CFM Routing Flag | ||
| COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | Completion Subinventory | |
| COMPLETION_LOCATOR_ID | NUMBER | Completion Locator Id | ||
| MIXED_MODEL_MAP_FLAG | NUMBER | Mixed Model Map Flag | ||
| PRIORITY | NUMBER | Priority | ||
| CTP_FLAG | NUMBER | CTP Flag | ||
| ROUTING_SEQUENCE_ID | NUMBER | Routing Sequence Id | ||
| NEW_ROUTING_REVISION | VARCHAR2 | (3) | New Routing Revision | |
| ROUTING_COMMENT | VARCHAR2 | (240) | Routing Comments | |
| ECO_FOR_PRODUCTION | NUMBER | WIP Only ECO | ||
| DESIGNATOR_SELECTION_TYPE | NUMBER | Used by copy and transfer transactions. Valid values are All, Primary and Specific | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate Bom Designator | |
| TRANSFER_OR_COPY | VARCHAR2 | (1) | Transfer Or Copy. Valid values are T --> Transfer, C --> Copy | |
| TRANSFER_OR_COPY_ITEM | NUMBER | Transfer Or Copy the engineering item to manufacturing | ||
| TRANSFER_OR_COPY_BILL | NUMBER | Transfer Or Copy the engineering bill to manufacturing | ||
| TRANSFER_OR_COPY_ROUTING | NUMBER | Transfer Or Copy the engineering routing to manufacturing | ||
| COPY_TO_ITEM | VARCHAR2 | (2000) | Name of the new manufacturing item | |
| COPY_TO_ITEM_DESC | VARCHAR2 | (240) | Description for the new manufacturing item | |
| IMPLEMENTED_ONLY | NUMBER | Used by copy and transfer to choose the components and operations | ||
| SELECTION_OPTION | NUMBER | Selection criteria applied to choose the components and operations for copy or transfer | ||
| SELECTION_DATE | DATE | Selection Date | ||
| SELECTION_UNIT_NUMBER | VARCHAR2 | (30) | Selection Unit Number | |
| CONCATENATED_COPY_SEGMENTS | VARCHAR2 | (2000) | Concatenated Copy Segments | |
| CHANGE_ID | NUMBER | Yes | Change Id | |
| NEW_ITEM_REVISION_ID | NUMBER | New item revision identifier | ||
| CURRENT_ITEM_REVISION_ID | NUMBER | Current revision internal id | ||
| CURRENT_LIFECYCLE_STATE_ID | NUMBER | Current lifecycle state internal id | ||
| NEW_LIFECYCLE_STATE_ID | NUMBER | New lifecycle state internal id | ||
| STATUS_CODE | NUMBER | Yes | Status Code | |
| FROM_END_ITEM_ID | NUMBER | From end item id | ||
| FROM_END_ITEM_REV_ID | NUMBER | From end item revision id | ||
| FROM_END_ITEM_STRC_REV_ID | NUMBER | From end item source revision id | ||
| ENABLE_ITEM_IN_LOCAL_ORG | VARCHAR2 | (1) | Enable item in local organization | |
| CREATE_BOM_IN_LOCAL_ORG | VARCHAR2 | (1) | Create bill of material in local organization | |
| CURRENT_STRUCTURE_REV_ID | NUMBER | Current structure revision id | ||
| NEW_STRUCTURE_REVISION | VARCHAR2 | (80) | New structure revision | |
| PARENT_REVISED_ITEM_SEQ_ID | NUMBER | Parent revised item sequence id | ||
| PLAN_LEVEL | NUMBER | Plan level | ||
| NEW_REVISION_LABEL | VARCHAR2 | (80) | Label of new revision | |
| NEW_REVISION_REASON | VARCHAR2 | (30) | Reason for new revision | |
| NEW_REV_DESCRIPTION | VARCHAR2 | (240) | Description of new revision | |
| IMPLEMENTATION_REQ_ID | NUMBER | Implementation concurrent request id | ||
| NEW_ITEM_DESCRIPTION | VARCHAR2 | (240) | New item description |
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;
ENG.ENG_REVISED_ITEMS does not reference any database object
ENG.ENG_REVISED_ITEMS is referenced by following:
ENG
ENG_REVISED_ITEMS#
|
|
|
|