eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ENG.ENG_REVISED_ITEMS_INTERFACE

Object Details

Object Name:	ENG_REVISED_ITEMS_INTERFACE
Object Type:	TABLE
Owner:	ENG
FND Design Data:	ENG.ENG_REVISED_ITEMS_INTERFACE
Subobject Name:
Status:	VALID

The ENG_REVISED_ITEMS_INTERFACE table serves two purposes. First, it
is a base table for the developer descriptive flexfield in the Mass
Change Bills of Material window. The columns used for this purpose all
refer to the mass change process in their descriptions.
.
Secondly, this table acts as an open interface table. You can
temporarily store information about revised items on an engineering
change order. This table contains user friendly columns which allow
you to easily enter your data as well as their corresponding foreign
keys. Oracle Engineering will fill in the column you do not
enter after performing the proper validation. For example,if you enter
the ORGANIZATION_CODE, Oracle Engineering will fill in the
corresponding ORGANIZATION_ID for you.
.
The REQUESTOR_ID and COMMENTS columns are used by the open
interface. These columns exist so the user can enter additional
information while rescheduling the revised item through the open
interface. The values in these columns are copied into the
SCHEDULED_DATE history table ENG_CURRENT_SCHEDULED_DATES, along with
the new SCHEDULED_DATE value.
You should not use the before mentioned "mass change" columns when
entering open interface data.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENG_REVISED_ITEMS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REVISED_ITEM_ID
ENG_REVISED_ITEMS_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORGANIZATION_ID CHANGE_NOTICE REVISED_ITEM_ID ENG_REVISED_ITEMS_IFCE_KEY
ENG_REVISED_ITEMS_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REVISED_ITEM_SEQUENCE_ID
ENG_REVISED_ITEMS_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ENG_CHANGES_IFCE_KEY
ENG_REVISED_ITEMS_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID

Columns

Name	Datatype	Length	Comments
CHANGE_NOTICE	VARCHAR2	(10)	Engineering change order number
ORGANIZATION_ID	NUMBER		Organization identifier
REVISED_ITEM_ID	NUMBER		Identifier for the revised item
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
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		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		Status of the revised item
SCHEDULED_DATE	DATE		Effective date of the revised item
BILL_SEQUENCE_ID	NUMBER		Bill of material unique identifier
MRP_ACTIVE	NUMBER		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		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
TRANSACTION_ID	NUMBER		Row identifier
TRANSACTION_TYPE	VARCHAR2	(10)	Type of action: Create, Update, or Delete
PROCESS_FLAG	NUMBER		Row status
ORGANIZATION_CODE	VARCHAR2	(3)	Abbreviation for organization name
REQUESTOR_ID	NUMBER		Identifier of user who is requesting that this item be rescheduled
COMMENTS	VARCHAR2	(240)	Comments on why this item is being rescheduled
REVISED_ITEM_NUMBER	VARCHAR2	(81)	Concatenated item segments of the revised item
ASSEMBLY_ITEM_NUMBER	VARCHAR2	(81)	Concatenated item segments of the assembly
USE_UP_ITEM_NUMBER	VARCHAR2	(81)	Concatenated item segments of the use up item
APPROVAL_LIST_NAME	VARCHAR2	(10)	Name of the approval list
BASE_ITEM_ID	NUMBER		Base item identifier
ENG_REVISED_ITEMS_IFCE_KEY	VARCHAR2	(30)	User defined identifier to link rows pertaining to the same revised item
ENG_CHANGES_IFCE_KEY	VARCHAR2	(30)	User defined identifier to link rows pertaining to the same business object
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	From End Item Unit Number
NEW_RTG_REVISION	VARCHAR2	(3)	New Routing Revision
FROM_END_ITEM_REV_ID	VARCHAR2	(240)	From end item revision id
FROM_END_ITEM_NUMBER	VARCHAR2	(81)	From end item number
FROM_END_ITEM_REVISION	VARCHAR2	(3)	From end item revision
PARENT_REVISED_ITEM_NAME	VARCHAR2	(240)	Parent revised item name
PARENT_ALTERNATE_NAME	VARCHAR2	(3)	Parent alternate name
UPDATED_ITEM_REVISION	VARCHAR2	(240)	Updated item revision
NEW_SCHEDULED_DATE	DATE		New scheduled date
FROM_ITEM_REVISION	VARCHAR2	(3)	From item revision
NEW_REVISION_LABEL	VARCHAR2	(80)	New revision label
NEW_REVISED_ITEM_REV_DESC	VARCHAR2	(240)	New revised item revision description
NEW_REVISION_REASON	VARCHAR2	(80)	New revision reason

Query Text

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
,      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
,      TRANSACTION_ID
,      TRANSACTION_TYPE
,      PROCESS_FLAG
,      ORGANIZATION_CODE
,      REQUESTOR_ID
,      COMMENTS
,      REVISED_ITEM_NUMBER
,      ASSEMBLY_ITEM_NUMBER
,      USE_UP_ITEM_NUMBER
,      APPROVAL_LIST_NAME
,      BASE_ITEM_ID
,      ENG_REVISED_ITEMS_IFCE_KEY
,      ENG_CHANGES_IFCE_KEY
,      FROM_END_ITEM_UNIT_NUMBER
,      NEW_RTG_REVISION
,      FROM_END_ITEM_REV_ID
,      FROM_END_ITEM_NUMBER
,      FROM_END_ITEM_REVISION
,      PARENT_REVISED_ITEM_NAME
,      PARENT_ALTERNATE_NAME
,      UPDATED_ITEM_REVISION
,      NEW_SCHEDULED_DATE
,      FROM_ITEM_REVISION
,      NEW_REVISION_LABEL
,      NEW_REVISED_ITEM_REV_DESC
,      NEW_REVISION_REASON
FROM ENG.ENG_REVISED_ITEMS_INTERFACE;

Dependencies

[top of page]

ENG.ENG_REVISED_ITEMS_INTERFACE does not reference any database object

ENG.ENG_REVISED_ITEMS_INTERFACE is referenced by following:

APPS: ENG_REVISED_ITEMS_INTERFACE