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]

VIEW: APPS.ENG_REVISED_ITEMS_SCHEDULE_V

Object Details

Object Name:	ENG_REVISED_ITEMS_SCHEDULE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ENG.ENG_REVISED_ITEMS_SCHEDULE_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
CHANGE_NOTICE	VARCHAR2	(10)	Yes	Engineering change order number
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
ROW_ID	ROWID	(10)		-Rowid from table
RESPONSIBLE_ORGANIZATION_ID	NUMBER			ECO Department Identifier
NEW_ITEM_REVISION	VARCHAR2	(3)		New revision of the revised item
REVISED_ITEM_STATUS_TYPE	NUMBER		Yes	- Status of the revised item
REVISED_ITEM_STATUS	VARCHAR2	(80)	Yes	Lookup meaning
SCHEDULED_DATE	DATE		Yes	Effective date of the revised item
REVISED_ITEM_ID	NUMBER		Yes	Revised item identifier
REVISED_ITEM	VARCHAR2	(40)		Item name consisting of concatenated item flexfield segments
REVISED_ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
ITEM_TYPE	VARCHAR2	(80)		QuickCode meaning
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Alternate designator code
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_PLAN_NAME	VARCHAR2	(10)		Use up plan name
DISPOSITION_TYPE	NUMBER		Yes	Disposition type (information purposes only)
DISPOSITION	VARCHAR2	(80)		Lookup meaning
CHANGE_ORDER_TYPE	VARCHAR2	(80)	Yes	Change order type name
CHANGE_ORDER_TYPE_ID	NUMBER		Yes	Unique identifier of a change order type
REASON_CODE	VARCHAR2	(10)		Reason code
PRIORITY_CODE	VARCHAR2	(10)		Priority code
INITIATION_DATE	DATE		Yes	Creation date of the ECO
APPROVAL_STATUS_TYPE	NUMBER			Approval status type
APPROVAL_STATUS	VARCHAR2	(80)		Lookup meaning
APPROVAL_REQUEST_DATE	DATE			Date the approval status is change to 'Approval requested'
APPROVAL_DATE	DATE			Date the ECO was approved
IMPLEMENTATION_DATE	DATE			Implementation date of the revised item
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
DESCRIPTIVE_TEXT	VARCHAR2	(2000)		Descriptive text
CANCELLATION_DATE	DATE			Cancellation date of the revised item
CANCEL_COMMENTS	VARCHAR2	(240)		Cancellation comments
AUTO_IMPLEMENT_DATE	DATE			Date that the revised item was scheduled for auto implementation
AUTO_IMPLEMENTED_FLAG	NUMBER			Date that the revised item was scheduled for auto implementation
EARLY_SCHEDULE_DATE	DATE			Early effective date
BILL_SEQUENCE_ID	NUMBER			Bill of material unique identifier
REVISED_ITEM_SEQUENCE_ID	NUMBER		Yes	Unique identifier of a revised item
ECO_STATUS_TYPE	NUMBER		Yes	Engineering change order status
ECO_STATUS	VARCHAR2	(80)	Yes	Lookup meaning
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
DEPARTMENT_NAME	VARCHAR2	(240)		Department name

Query Text

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


SELECT CHANGE_NOTICE
,      ORGANIZATION_ID
,      ROW_ID
,      RESPONSIBLE_ORGANIZATION_ID
,      NEW_ITEM_REVISION
,      REVISED_ITEM_STATUS_TYPE
,      REVISED_ITEM_STATUS
,      SCHEDULED_DATE
,      REVISED_ITEM_ID
,      REVISED_ITEM
,      REVISED_ITEM_DESCRIPTION
,      ITEM_TYPE
,      ALTERNATE_BOM_DESIGNATOR
,      MRP_ACTIVE
,      UPDATE_WIP
,      USE_UP
,      USE_UP_ITEM_ID
,      USE_UP_PLAN_NAME
,      DISPOSITION_TYPE
,      DISPOSITION
,      CHANGE_ORDER_TYPE
,      CHANGE_ORDER_TYPE_ID
,      REASON_CODE
,      PRIORITY_CODE
,      INITIATION_DATE
,      APPROVAL_STATUS_TYPE
,      APPROVAL_STATUS
,      APPROVAL_REQUEST_DATE
,      APPROVAL_DATE
,      IMPLEMENTATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTIVE_TEXT
,      CANCELLATION_DATE
,      CANCEL_COMMENTS
,      AUTO_IMPLEMENT_DATE
,      AUTO_IMPLEMENTED_FLAG
,      EARLY_SCHEDULE_DATE
,      BILL_SEQUENCE_ID
,      REVISED_ITEM_SEQUENCE_ID
,      ECO_STATUS_TYPE
,      ECO_STATUS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DEPARTMENT_NAME
FROM APPS.ENG_REVISED_ITEMS_SCHEDULE_V;

Dependencies

[top of page]

APPS.ENG_REVISED_ITEMS_SCHEDULE_V references the following:

APPS: BOM_BILL_OF_MATERIALS; ENG_CHANGE_ORDER_TYPES_VL; ENG_ENGINEERING_CHANGES; ENG_REVISED_ITEMS; FND_COMMON_LOOKUPS; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; MFG_LOOKUPS; MTL_SYSTEM_ITEMS_B_KFV; MTL_SYSTEM_ITEMS_TL

APPS.ENG_REVISED_ITEMS_SCHEDULE_V is not referenced by any database object