[Home] [Help] [Dependency Information]
Object Name: | AK_CRITERIA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AK.AK_CRITERIA_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Yes | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Yes | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Yes | Application id where the region will be used. |
REGION_CODE | VARCHAR2 | (30) | Yes | Region code for a given region. |
CUSTOMIZATION_LEVEL_ID | NUMBER | (15) | Yes | Level Id to indicate the level of customization. |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Yes | Application Id where the attribute will be used |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Attribute Code of the given attribute |
ITEM_NAME | VARCHAR2 | (30) | Item name. | |
VIEW_USAGE_NAME | VARCHAR2 | (80) | View Usage name. | |
VIEW_ATTRIBUTE_NAME | VARCHAR2 | (80) | View Attribute Name. | |
SEQUENCE_NUMBER | NUMBER | (15) | Yes | Sequence Number of the criteria within a given customization |
OPERATION | VARCHAR2 | (30) | Yes | Operation used for the given criteria. Values come in from the lookup ICX_CONDITIONS. |
VALUE_VARCHAR2 | VARCHAR2 | (240) | Value of the criteria if the datatype is varchar2. | |
VALUE_NUMBER | NUMBER | (15) | Value of the criteria if the datatype is number. | |
VALUE_DATE | DATE | Value of the criteria if the datatype is date | ||
CRITERIA_JOIN_CONDITION | VARCHAR2 | (3) | Join condition used, if the customization has a criteria associated with it. Possible values that it can take are "AND" and "OR". | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
CREATION_DATE | DATE | Yes | Standard Who Column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column. |
START_DATE_ACTIVE | DATE | Yes | Standard Who Column. | |
END_DATE_ACTIVE | DATE | Standard Who Column. |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMIZATION_APPLICATION_ID
, CUSTOMIZATION_CODE
, REGION_APPLICATION_ID
, REGION_CODE
, CUSTOMIZATION_LEVEL_ID
, ATTRIBUTE_APPLICATION_ID
, ATTRIBUTE_CODE
, ITEM_NAME
, VIEW_USAGE_NAME
, VIEW_ATTRIBUTE_NAME
, SEQUENCE_NUMBER
, OPERATION
, VALUE_VARCHAR2
, VALUE_NUMBER
, VALUE_DATE
, CRITERIA_JOIN_CONDITION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM APPS.AK_CRITERIA_V;
APPS.AK_CRITERIA_V is not referenced by any database object
|
|
|