DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.ENG_REVISED_ITEMS_ERV

Object Details
Object Name: ENG_REVISED_ITEMS_ERV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_REVISED_ITEMS_ERV
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
CHANGE_NOTICE VARCHAR2 (10) Yes Engineering change order number
ORGANIZATION_ID NUMBER
Yes Organization identifier
REVISED_ITEM_ID NUMBER
Yes Revised item identifier
REVISED_ITEM_NO VARCHAR2 (40)
Revised item number
REVISED_ITEM_DESCRIPTION VARCHAR2 (240)
Revised item's description
ITEM_TYPE VARCHAR2 (80)
User defined item type
BOM_ITEM_TYPE NUMBER
Yes Type of item
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1) Yes Assemble to Order flag
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating whether item may have components requiring ATP check
PICK_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating if shippable components should be picked
BASE_ITEM_ID NUMBER

Base item identifier
BOM_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating if item may appear on a bill
BUILD_IN_WIP_FLAG VARCHAR2 (1) Yes Flag indicating if item can be built in WIP
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
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate desigantor code for bill
ASSEMBLY_TYPE NUMBER

Flag indicating manufacturing or engineering bill
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
AUTO_IMPLEMENTED_FLAG NUMBER

Flag indicating if revised item was auto implemented
EARLY_SCHEDULE_DATE DATE

Early effective date
STATUS_TYPE NUMBER
Yes Status code of the revised item
REVISED_ITEM_STATUS VARCHAR2 (80) 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
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
USE_UP_ITEM_NO VARCHAR2 (40)
Use up item number
USE_UP_ITEM_DESC VARCHAR2 (240)
Used up item description
REVISED_ITEM_SEQUENCE_ID NUMBER
Yes Unique identifier of a revised item
USE_UP_PLAN_NAME VARCHAR2 (10)
Use up plan name
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
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
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
From End Item Unit Number
DISPOSITION VARCHAR2 (80) Yes Disposition
FROM_WIP_ENTITY_ID NUMBER

From Wip Entity Id
FROM_WORK_ORDER VARCHAR2 (240)
From Work Order
TO_WIP_ENTITY_ID NUMBER

To Wip Entity Id
TO_WORK_ORDER VARCHAR2 (240)
To Work Order
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
COMPLETION_LOCATOR CHAR (1)
Completion locator
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_TYPE NUMBER

Routing type
ROUTING_COMMENT VARCHAR2 (240)
Routing Comment
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original System Reference
ECO_FOR_PRODUCTION NUMBER

WIP Only ECO
NEW_ITEM_REVISION_DESC VARCHAR2 (240)
Description for the new item revision
DESIGNATOR_SELECTION_TYPE NUMBER

Designator Selection Type
DESIGNATOR_NAME VARCHAR2 (10)
Alternate Bom designator choosen for copy or transfer
TRANSFER_OR_COPY VARCHAR2 (1)
Transfer Or Copy
TRANSFER_OR_COPY_ITEM NUMBER

Transfer Or Copy Item
TRANSFER_OR_COPY_BILL NUMBER

Transfer Or Copy Bill
TRANSFER_OR_COPY_ROUTING NUMBER

Transfer Or Copy Routing
COPY_TO_ITEM VARCHAR2 (2000)
Copy To Item
COPY_TO_ITEM_DESC VARCHAR2 (240)
Copy To Item Description
IMPLEMENTED_ONLY NUMBER

Implemented Only
SELECTION_OPTION NUMBER

Selection Option
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 identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      CHANGE_NOTICE
,      ORGANIZATION_ID
,      REVISED_ITEM_ID
,      REVISED_ITEM_NO
,      REVISED_ITEM_DESCRIPTION
,      ITEM_TYPE
,      BOM_ITEM_TYPE
,      REPLENISH_TO_ORDER_FLAG
,      ATP_COMPONENTS_FLAG
,      PICK_COMPONENTS_FLAG
,      BASE_ITEM_ID
,      BOM_ENABLED_FLAG
,      BUILD_IN_WIP_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ALTERNATE_BOM_DESIGNATOR
,      ASSEMBLY_TYPE
,      IMPLEMENTATION_DATE
,      DESCRIPTIVE_TEXT
,      CANCELLATION_DATE
,      CANCEL_COMMENTS
,      DISPOSITION_TYPE
,      NEW_ITEM_REVISION
,      AUTO_IMPLEMENT_DATE
,      AUTO_IMPLEMENTED_FLAG
,      EARLY_SCHEDULE_DATE
,      STATUS_TYPE
,      REVISED_ITEM_STATUS
,      SCHEDULED_DATE
,      BILL_SEQUENCE_ID
,      MRP_ACTIVE
,      UPDATE_WIP
,      USE_UP
,      USE_UP_ITEM_ID
,      USE_UP_ITEM_NO
,      USE_UP_ITEM_DESC
,      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_END_ITEM_UNIT_NUMBER
,      DISPOSITION
,      FROM_WIP_ENTITY_ID
,      FROM_WORK_ORDER
,      TO_WIP_ENTITY_ID
,      TO_WORK_ORDER
,      FROM_CUM_QTY
,      LOT_NUMBER
,      CFM_ROUTING_FLAG
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      COMPLETION_LOCATOR
,      MIXED_MODEL_MAP_FLAG
,      PRIORITY
,      CTP_FLAG
,      ROUTING_SEQUENCE_ID
,      NEW_ROUTING_REVISION
,      ROUTING_TYPE
,      ROUTING_COMMENT
,      ORIGINAL_SYSTEM_REFERENCE
,      ECO_FOR_PRODUCTION
,      NEW_ITEM_REVISION_DESC
,      DESIGNATOR_SELECTION_TYPE
,      DESIGNATOR_NAME
,      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
FROM APPS.ENG_REVISED_ITEMS_ERV;

Dependencies

[top of page]

APPS.ENG_REVISED_ITEMS_ERV references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
SynonymBOM_OPERATIONAL_ROUTINGS
SynonymENG_REVISED_ITEMS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
ViewMFG_LOOKUPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_ITEM_REVISIONS
ViewMTL_SYSTEM_ITEMS_VL
SynonymWIP_ENTITIES

APPS.ENG_REVISED_ITEMS_ERV is not referenced by any database object