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

VIEW: APPS.ENG_CHANGE_ORDER_TYPES_VAL_V

Object Details
Object Name: ENG_CHANGE_ORDER_TYPES_VAL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_CHANGE_ORDER_TYPES_VAL_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


ENG_CHANGE_ORDER_TYPES_VAL_V stores information about
engineering change order types that are not disabled. You can use
change order types to group ECOs and to allow access to engineering
items and engineering bills of material.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CHANGE_ORDER_TYPE VARCHAR2 (80) Yes Change order type name
DESCRIPTION VARCHAR2 (240)
Description
CHANGE_ORDER_TYPE_ID NUMBER
Yes Unique identifier of a change order type
ASSEMBLY_TYPE NUMBER

Item access (manufacturing or engineering)
CHANGE_ORDER_ORGANIZATION_ID NUMBER

ECO department identifier (not currently used)
BILL_TYPE VARCHAR2 (80) Yes Type of bill - engineering or manufacturing
CHANGE_MGMT_TYPE_CODE VARCHAR2 (30)
Change Mgmt Type Code
TYPE_CLASSIFICATION VARCHAR2 (30)
Classification type
Query Text

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


SELECT CHANGE_ORDER_TYPE
,      DESCRIPTION
,      CHANGE_ORDER_TYPE_ID
,      ASSEMBLY_TYPE
,      CHANGE_ORDER_ORGANIZATION_ID
,      BILL_TYPE
,      CHANGE_MGMT_TYPE_CODE
,      TYPE_CLASSIFICATION
FROM APPS.ENG_CHANGE_ORDER_TYPES_VAL_V;

Dependencies

[top of page]

APPS.ENG_CHANGE_ORDER_TYPES_VAL_V references the following:

SchemaAPPS
ViewENG_CHANGE_ORDER_TYPES_V
PL/SQL PackageFND_PROFILE - show dependent code
ViewMFG_LOOKUPS

APPS.ENG_CHANGE_ORDER_TYPES_VAL_V is not referenced by any database object