[Home] [Help] [Dependency Information]
Object Name: | ENG_CHANGE_POLICIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ENG.ENG_CHANGE_POLICIES_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
ENG_CHANGE_POLICIES_V stores information to display the different lifecycle change policies
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_CODE | VARCHAR2 | (30) | Attribute code | |
ATTRIBUTE_OBJECT_NAME | VARCHAR2 | (30) | Attribute object name | |
ATTRIBUTE_COLUMN_TYPE | VARCHAR2 | (10) | Datatype of the attribute | |
ATTRIBUTE_NUMBER_VALUE | NUMBER | Numeric value of the attribute | ||
ATTRIBUTE_CHAR_VALUE | VARCHAR2 | (30) | Character value of the attribute | |
POLICY_COLUMN_TYPE | VARCHAR2 | (10) | Yes | Datatype of the policy column |
POLICY_NUMBER_VALUE | NUMBER | Numeric value of the policy | ||
POLICY_CHAR_VALUE | VARCHAR2 | (30) | Character value of the policy | |
POLICY_OBJECT_NAME | VARCHAR2 | (30) | Yes | Object name |
POLICY_OBJECT_PK1_VALUE | VARCHAR2 | (30) | Yes | Primary key of the object |
POLICY_OBJECT_PK2_VALUE | VARCHAR2 | (30) | Primary key of the object | |
POLICY_OBJECT_PK3_VALUE | VARCHAR2 | (30) | Primary key of the object | |
POLICY_OBJECT_PK4_VALUE | VARCHAR2 | (30) | Primary key of the object | |
POLICY_OBJECT_PK5_VALUE | VARCHAR2 | (30) | Primary key of the object | |
POLICY_CODE | VARCHAR2 | (30) | Yes | Policy code |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_CODE
, ATTRIBUTE_OBJECT_NAME
, ATTRIBUTE_COLUMN_TYPE
, ATTRIBUTE_NUMBER_VALUE
, ATTRIBUTE_CHAR_VALUE
, POLICY_COLUMN_TYPE
, POLICY_NUMBER_VALUE
, POLICY_CHAR_VALUE
, POLICY_OBJECT_NAME
, POLICY_OBJECT_PK1_VALUE
, POLICY_OBJECT_PK2_VALUE
, POLICY_OBJECT_PK3_VALUE
, POLICY_OBJECT_PK4_VALUE
, POLICY_OBJECT_PK5_VALUE
, POLICY_CODE
FROM APPS.ENG_CHANGE_POLICIES_V;
|
|
|