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_CURRENT_SCHEDULED_DATES

Object Details

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

ENG_CURRENT_SCHEDULED_DATES stores the effective date history for each
revised item on an engineering change order. Every time you change the
effective date for a revised item on an ECO, a new row is inserted
into this table. The SCHEDULE_ID column differentiates between
records for the same revised item and the ECO.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENG_CURRENT_SCHEDULED_DATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REVISED_ITEM_SEQUENCE_ID SCHEDULE_ID
ENG_CURRENT_SCHEDULED_DATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID CHANGE_NOTICE

Columns

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 ID
SCHEDULED_DATE	DATE		Yes	Effective date
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
SCHEDULE_ID	NUMBER		Yes	Unique identifier
EMPLOYEE_ID	NUMBER			Employee ID
COMMENTS	VARCHAR2	(240)		Comments
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
REVISED_ITEM_SEQUENCE_ID	NUMBER			Unique identifier of a revised item
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)		Original system that data for the current record has come from
CHANGE_ID	NUMBER			Change Id
OLD_EMPLOYEE_ID	NUMBER			Old Employee ID

Query Text

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


SELECT CHANGE_NOTICE
,      ORGANIZATION_ID
,      REVISED_ITEM_ID
,      SCHEDULED_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SCHEDULE_ID
,      EMPLOYEE_ID
,      COMMENTS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REVISED_ITEM_SEQUENCE_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      CHANGE_ID
,      OLD_EMPLOYEE_ID
FROM ENG.ENG_CURRENT_SCHEDULED_DATES;

Dependencies

[top of page]

ENG.ENG_CURRENT_SCHEDULED_DATES does not reference any database object

ENG.ENG_CURRENT_SCHEDULED_DATES is referenced by following:

APPS: ENG_CURRENT_SCHEDULED_DATES