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.ENGFV_ENGINEERING_CHNG_ORDERS

Object Details

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

View Type

A Business Intelligence System view

This shows the information about controlling and requesting a change to an existing product or product under development which will change the product revision.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ECO_NAME	VARCHAR2	(10)	Yes	Engineering change order
ORGANIZATION_CODE	VARCHAR2	(3)
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization name
DESCRIPTION	VARCHAR2	(2000)		ECO description
ECO_CREATION_DATE	DATE		Yes	Date ECO was created
IMPLEMENTATION_DATE	DATE			Date ECO is implemented
CANCELLATION_DATE	DATE			Date ECO is cancelled
CANCELLATION_COMMENTS	VARCHAR2	(240)		Comments about the cancellation
PRIORITY_CODE	VARCHAR2	(10)		Priority of the ECO
REASON_CODE	VARCHAR2	(10)		Reason for the ECO
ENG_IMPLEMENTATION_COSTS	NUMBER			Engineering cost to implement the ECO
MFG_IMPLEMENTATION_COSTS	NUMBER			Manufacturing cost to implement the ECO
APPROVAL_DATE	DATE			Date ECO was approved
APPROVAL_REQUEST_DATE	DATE			Date ECO was requested for approval
_LA:APPROVAL_STATUS_TYPE	CHAR	(71)		Approval status
_LA:STATUS_TYPE	CHAR	(53)		ECO status
PROJECT_NAME	VARCHAR2	(30)
TASK_NAME	VARCHAR2	(25)
REQUESTOR_NAME	VARCHAR2	(240)		Name of person who requested the ECO
APPROVAL_LIST_NAME	VARCHAR2	(10)		List of people who need to approve the ECO
ECO_RESPONSIBLE_ORGANIZATION	VARCHAR2	(240)		Department which owns the ECO
CHANGE_TYPE_CODE	VARCHAR2	(80)	Yes	Change type
_DF	CHAR	(34)
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
REQUESTOR_ID	NUMBER			Requestor identifier
APPROVAL_LIST_ID	NUMBER			Approval list identifier
CHANGE_ORDER_TYPE_ID	NUMBER		Yes	Change type identifier
RESPONSIBLE_ORGANIZATION_ID	NUMBER			ECO department identifier
PROJECT_ID	NUMBER
TASK_ID	NUMBER
CREATED_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER		Yes	Standard WHO column
UPDATED_DATE	DATE		Yes	Standard WHO column
UPDATED_BY	NUMBER		Yes	Standard WHO column

Query Text

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


SELECT ECO_NAME
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      DESCRIPTION
,      ECO_CREATION_DATE
,      IMPLEMENTATION_DATE
,      CANCELLATION_DATE
,      CANCELLATION_COMMENTS
,      PRIORITY_CODE
,      REASON_CODE
,      ENG_IMPLEMENTATION_COSTS
,      MFG_IMPLEMENTATION_COSTS
,      APPROVAL_DATE
,      APPROVAL_REQUEST_DATE
,      _LA:APPROVAL_STATUS_TYPE
,      _LA:STATUS_TYPE
,      PROJECT_NAME
,      TASK_NAME
,      REQUESTOR_NAME
,      APPROVAL_LIST_NAME
,      ECO_RESPONSIBLE_ORGANIZATION
,      CHANGE_TYPE_CODE
,      _DF
,      ORGANIZATION_ID
,      REQUESTOR_ID
,      APPROVAL_LIST_ID
,      CHANGE_ORDER_TYPE_ID
,      RESPONSIBLE_ORGANIZATION_ID
,      PROJECT_ID
,      TASK_ID
,      CREATED_DATE
,      CREATED_BY
,      UPDATED_DATE
,      UPDATED_BY
FROM APPS.ENGFV_ENGINEERING_CHNG_ORDERS;

Dependencies

[top of page]

APPS.ENGFV_ENGINEERING_CHNG_ORDERS references the following:

APPS: ENG_CHANGE_ORDER_TYPES_TL; ENG_ECN_APPROVAL_LISTS; ENG_ENGINEERING_CHANGES; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; HZ_PARTIES; MTL_PARAMETERS; PA_PROJECTS_ALL; PA_TASKS; PER_PEOPLE_F

APPS.ENGFV_ENGINEERING_CHNG_ORDERS is not referenced by any database object