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

Object Details

Object Name:	AK_CRITERIA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AK.AK_CRITERIA_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

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.

Query Text

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;

Dependencies

[top of page]

APPS.AK_CRITERIA_V references the following:

APPS: AK_CRITERIA; AK_CUSTOMIZATIONS; AK_CUSTOM_REGIONS; AK_REGION_ITEMS

APPS.AK_CRITERIA_V is not referenced by any database object