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_WEB_SCHEDULE_V

Object Details

Object Name:	ENG_WEB_SCHEDULE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ENG.ENG_WEB_SCHEDULE_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

The revised items view is designed for use in Oracle Self Service Web
Applications.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REVISED_ITEM_SEQUENCE_ID	NUMBER		Yes	Primary key of revised iem
CHANGE_NOTICE	VARCHAR2	(10)	Yes	ECO
ORGANIZATION_CODE	VARCHAR2	(3)		Three character organization code
CHANGE_ORDER_TYPE	VARCHAR2	(80)		ECO Type
ECO_STATUS	VARCHAR2	(80)	Yes	ECO Status
REQUESTOR	VARCHAR2	(240)		Employee requesting this ECO
DEPARTMENT	VARCHAR2	(240)		ECO Department
REASON_CODE	VARCHAR2	(10)		Reason for ECO
REASON_DESCRIPTION	VARCHAR2	(50)		Description of reason code
PRIORITY_CODE	VARCHAR2	(10)		ECO priority
INITIATION_DATE	DATE		Yes	ECO Creation Date
APPROVAL_STATUS	VARCHAR2	(80)		ECO Approval Status
APPROVAL_REQUEST_DATE	DATE			Date ECO was submitted for approval
APPROVAL_DATE	DATE			Date ECO approved
REVISED_ITEM_ID	NUMBER		Yes	Item Id of revised item
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
REVISED_ITEM	VARCHAR2	(40)		Revised Item concatenated segments
PADDED_REVISED_ITEM	VARCHAR2	(40)		Padded concatenated segments of revised item. Used for ordering.
REVISED_ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Bill alternate
NEW_ITEM_REVISION	VARCHAR2	(3)		New Item Revision
REVISED_ITEM_STATUS	VARCHAR2	(80)	Yes	Status of Revised Item
SCHEDULED_DATE	DATE		Yes	Effective Date
IMPLEMENTATION_DATE	DATE			Date Revised Item was implemented
MRP_ACTIVE	VARCHAR2	(80)	Yes	MRP Active flag: asterisk= yes, blank=no
UPDATE_WIP	VARCHAR2	(80)	Yes	Update WIP Flag: asterisk = yes, blank = no
BILL_SEQUENCE_ID	NUMBER			Foreign key to Bill of Material being changed
ECO_DESCRIPTION	VARCHAR2	(2000)		ECO Description

Query Text

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


SELECT REVISED_ITEM_SEQUENCE_ID
,      CHANGE_NOTICE
,      ORGANIZATION_CODE
,      CHANGE_ORDER_TYPE
,      ECO_STATUS
,      REQUESTOR
,      DEPARTMENT
,      REASON_CODE
,      REASON_DESCRIPTION
,      PRIORITY_CODE
,      INITIATION_DATE
,      APPROVAL_STATUS
,      APPROVAL_REQUEST_DATE
,      APPROVAL_DATE
,      REVISED_ITEM_ID
,      ORGANIZATION_ID
,      REVISED_ITEM
,      PADDED_REVISED_ITEM
,      REVISED_ITEM_DESCRIPTION
,      ALTERNATE_BOM_DESIGNATOR
,      NEW_ITEM_REVISION
,      REVISED_ITEM_STATUS
,      SCHEDULED_DATE
,      IMPLEMENTATION_DATE
,      MRP_ACTIVE
,      UPDATE_WIP
,      BILL_SEQUENCE_ID
,      ECO_DESCRIPTION
FROM APPS.ENG_WEB_SCHEDULE_V;

Dependencies

[top of page]

APPS.ENG_WEB_SCHEDULE_V references the following:

APPS: BOM_BILL_OF_MATERIALS; ENG_CHANGE_ORDER_TYPES; ENG_CHANGE_REASONS; ENG_ENGINEERING_CHANGES; ENG_REVISED_ITEMS; FND_GLOBAL - show dependent code; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MFG_LOOKUPS; MTL_ITEM_FLEXFIELDS; MTL_PARAMETERS; PER_PEOPLE_F

APPS.ENG_WEB_SCHEDULE_V is referenced by following:

APPS: ICX_ENG_WEB_SCHEDULE_CS_V; ICX_ENG_WEB_SCHEDULE_PO_V; ICX_ENG_WEB_SCHEDULE_SO_V