[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ENG_REVISED_ITEMS_API_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ENG.ENG_REVISED_ITEMS_API_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CHANGE_NOTICE | VARCHAR2 | (10) | Yes | Engineering change order |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| REVISED_ITEM_ID | NUMBER | Yes | Revised item identifier | |
| REVISED_ITEM | VARCHAR2 | (40) | Revised item | |
| REVISED_ITEM_DESCRIPTION | VARCHAR2 | (240) | Revised item description | |
| 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 | Date revised item was implemented | ||
| DESCRIPTIVE_TEXT | VARCHAR2 | (240) | Revised item comment | |
| CANCELLATION_DATE | DATE | Date revised item was cancelled | ||
| CANCEL_COMMENTS | VARCHAR2 | (240) | Cancellation comments | |
| DISPOSITION_TYPE | NUMBER | Yes | Disposition Type | |
| DISPOSITION | VARCHAR2 | (80) | Yes | Disposition |
| NEW_ITEM_REVISION | VARCHAR2 | (3) | New item revision | |
| AUTO_IMPLEMENT_DATE | DATE | Date revised item was auto implemented | ||
| EARLY_SCHEDULE_DATE | DATE | Early schedule date | ||
| STATUS_TYPE | NUMBER | Yes | Revised item Status type | |
| REVISED_ITEM_STATUS | VARCHAR2 | (80) | Yes | Revised item status |
| SCHEDULED_DATE | DATE | Yes | Effective date | |
| BILL_SEQUENCE_ID | NUMBER | Bill identifier | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate designator of the bil | |
| ASSEMBLY_TYPE | NUMBER | Manufacturing bill(1) or Engineering bill(2) | ||
| MRP_ACTIVE | NUMBER | Yes | MRP Active | |
| UPDATE_WIP | NUMBER | Yes | Update WIP | |
| USE_UP | NUMBER | Yes | Use Up | |
| USE_UP_ITEM_ID | NUMBER | Use Up item identifier | ||
| USE_UP_ITEM | VARCHAR2 | (40) | Use Up item | |
| USE_UP_ITEM_DESCRIPTION | VARCHAR2 | (240) | Use Up item description | |
| REVISED_ITEM_SEQUENCE_ID | NUMBER | Yes | Revised item identifier | |
| USE_UP_PLAN_NAME | VARCHAR2 | (10) | Use Up Plan name | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure | |
| 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 | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_NOTICE
, ORGANIZATION_ID
, REVISED_ITEM_ID
, REVISED_ITEM
, REVISED_ITEM_DESCRIPTION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, IMPLEMENTATION_DATE
, DESCRIPTIVE_TEXT
, CANCELLATION_DATE
, CANCEL_COMMENTS
, DISPOSITION_TYPE
, DISPOSITION
, NEW_ITEM_REVISION
, AUTO_IMPLEMENT_DATE
, EARLY_SCHEDULE_DATE
, STATUS_TYPE
, REVISED_ITEM_STATUS
, SCHEDULED_DATE
, BILL_SEQUENCE_ID
, ALTERNATE_BOM_DESIGNATOR
, ASSEMBLY_TYPE
, MRP_ACTIVE
, UPDATE_WIP
, USE_UP
, USE_UP_ITEM_ID
, USE_UP_ITEM
, USE_UP_ITEM_DESCRIPTION
, REVISED_ITEM_SEQUENCE_ID
, USE_UP_PLAN_NAME
, 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
FROM APPS.ENG_REVISED_ITEMS_API_V;
APPS
BOM_BILL_OF_MATERIALS
ENG_REVISED_ITEMS
FND_GLOBAL
- show dependent code
MFG_LOOKUPS
MTL_ITEM_FLEXFIELDS
APPS.ENG_REVISED_ITEMS_API_V is not referenced by any database object
|
|
|
|