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

VIEW: APPS.ENG_REVISED_ITEMS_INTERFACE_V

Object Details
Object Name: ENG_REVISED_ITEMS_INTERFACE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_REVISED_ITEMS_INTERFACE_V
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)
Rowid from table ENG_REVISED_ITEMS_INTERFACE
CHANGE_NOTICE VARCHAR2 (10)
Engineering change order number
ORGANIZATION_ID NUMBER

Organization identifier
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
SCHEDULED_DATE DATE

Effective date of the revised items
MRP_ACTIVE NUMBER

Flag indicating whether the revised item is available to MRP
UPDATE_WIP NUMBER

Flag indicating whether or not to update repetitive schedules and unreleased discrete jobs in WIP when the revised item is implemented
USE_UP NUMBER

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

Unique identifier of a revised item
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate designator code that mass change uses to create ECOs
CATEGORY_SET_ID NUMBER

Category set identifier that mass change uses to create ECOs
STRUCTURE_ID NUMBER

Category structure identifier that mass change uses to create ECOs
ITEM_FROM VARCHAR2 (240)
Beginning of a range of items that mass change uses to create ECOs
ITEM_TO VARCHAR2 (240)
End of a range of items that mass change uses to create ECOs
CATEGORY_FROM VARCHAR2 (240)
Beginning of category range that mass change uses to create ECOs
CATEGORY_TO VARCHAR2 (240)
End of category range that mass change uses to create ECOs
DDF_CONTEXT VARCHAR2 (30)
Developer descriptive flexfield structure column for mass change form
INCREMENT_REV NUMBER

Increment the numerical revision when mass change creates ECOs (Yes/No)
ITEM_TYPE VARCHAR2 (30)
Item type that mass change uses to create ECOs
USE_UP_PLAN_NAME VARCHAR2 (10)
Use up plan name
ALTERNATE_SELECTION_CODE NUMBER

Type of alternate selection to use when mass change creates ECOs
BASE_ITEM_ID NUMBER

Base item identifier
BASE_MODEL VARCHAR2 (40)
Base model
BASE_DESCRIPTION VARCHAR2 (240)
Item description
USE_UP_ITEM_NO VARCHAR2 (40)
USE_UP_ITEM_NO
USE_UP_ITEM_DESCRIPTION VARCHAR2 (240)
Item description
CATEGORY_SET_NAME VARCHAR2 (30)
Category set name
ITEM_TYPE_NAME VARCHAR2 (80)
QuickCode meaning
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
From End Item Unit Number
Query Text

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


SELECT ROW_ID
,      CHANGE_NOTICE
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SCHEDULED_DATE
,      MRP_ACTIVE
,      UPDATE_WIP
,      USE_UP
,      USE_UP_ITEM_ID
,      REVISED_ITEM_SEQUENCE_ID
,      ALTERNATE_BOM_DESIGNATOR
,      CATEGORY_SET_ID
,      STRUCTURE_ID
,      ITEM_FROM
,      ITEM_TO
,      CATEGORY_FROM
,      CATEGORY_TO
,      DDF_CONTEXT
,      INCREMENT_REV
,      ITEM_TYPE
,      USE_UP_PLAN_NAME
,      ALTERNATE_SELECTION_CODE
,      BASE_ITEM_ID
,      BASE_MODEL
,      BASE_DESCRIPTION
,      USE_UP_ITEM_NO
,      USE_UP_ITEM_DESCRIPTION
,      CATEGORY_SET_NAME
,      ITEM_TYPE_NAME
,      FROM_END_ITEM_UNIT_NUMBER
FROM APPS.ENG_REVISED_ITEMS_INTERFACE_V;

Dependencies

[top of page]

APPS.ENG_REVISED_ITEMS_INTERFACE_V references the following:

SchemaAPPS
SynonymENG_REVISED_ITEMS_INTERFACE
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMTL_CATEGORY_SETS
ViewMTL_SYSTEM_ITEMS_VL

APPS.ENG_REVISED_ITEMS_INTERFACE_V is not referenced by any database object