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_REGION_LOV_RELATIONS_V

Object Details

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

View Type

MultiLingual view (a language resolved view of the data.)

View of AK_REGION_LOV_RELATIONS table. AK_REGION_LOV_RELATIONS contains the data that defines relationships between LOV regions and regions.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
REGION_APPLICATION_ID	NUMBER		Yes	Region Application Id of the region item which launches the LOV
REGION_APPLICATION_NAME	VARCHAR2	(240)	Yes	Region Application Name of the region item which launches the LOV
REGION_CODE	VARCHAR2	(30)	Yes	Region Code of the region item which launches the LOV
REGION_NAME	VARCHAR2	(80)	Yes	Region Name of the region item which launches the LOV
ATTRIBUTE_APPLICATION_ID	NUMBER		Yes	Attribute application id of the region item which launches this LOV
ATTRIBUTE_CODE	VARCHAR2	(30)	Yes	Attribute Code of the region item which launches the LOV
ATTRIBUTE_NAME	VARCHAR2	(80)	Yes	Attribute Name of the region item which launches the LOV
ITEM_NAME	VARCHAR2	(30)		Item Name
LOV_REGION_APPL_ID	NUMBER		Yes	Region Application ID of LOV Region
LOV_REGION_APPL_NAME	VARCHAR2	(240)	Yes	Region Application Name of LOV Region
LOV_REGION_CODE	VARCHAR2	(30)	Yes	Region code of LOV Region
LOV_REGION_NAME	VARCHAR2	(80)	Yes	Region Name of LOV region
LOV_ATTRIBUTE_APPL_ID	NUMBER		Yes	Attribute Application Id of LOV Region Item
LOV_ATTRIBUTE_CODE	VARCHAR2	(30)	Yes	Attribute code of LOV Region Item
LOV_ATTRIBUTE_NAME	VARCHAR2	(80)	Yes	Attribute name of LOV Region Item
LOV_ITEM_NAME	VARCHAR2	(30)		Item name for LOV region
BASE_REGION_APPL_ID	NUMBER		Yes	Region application id of the region which the LOV criteria is retreiving from or the LOV result is returning to.
BASE_REGION_CODE	VARCHAR2	(30)	Yes	Region code of the region which the LOV criteria is retreiving from or the LOV result is returning to.
BASE_REGION_NAME	VARCHAR2	(80)	Yes	Region name of the region which the LOV criteria is retreiving from or the LOV result is returning to
BASE_ATTRIBUTE_APPL_ID	NUMBER		Yes	ID of the application of the base attribute.
BASE_ATTRIBUTE_CODE	VARCHAR2	(30)	Yes	Code that identifies the base attribute.
BASE_ATTRIBUTE_NAME	VARCHAR2	(80)	Yes	Name that identifies the base attribute.
BASE_ITEM_NAME	VARCHAR2	(30)		Base Item Name
DIRECTION_FLAG	VARCHAR2	(30)	Yes	indicates this attribute value is a result returning to the caller or it's a criteria adding to another LOV
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
REQUIRED_FLAG	VARCHAR2	(1)	Yes	valid values of this column are 'Y' and 'N'

Query Text

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


SELECT ROW_ID
,      REGION_APPLICATION_ID
,      REGION_APPLICATION_NAME
,      REGION_CODE
,      REGION_NAME
,      ATTRIBUTE_APPLICATION_ID
,      ATTRIBUTE_CODE
,      ATTRIBUTE_NAME
,      ITEM_NAME
,      LOV_REGION_APPL_ID
,      LOV_REGION_APPL_NAME
,      LOV_REGION_CODE
,      LOV_REGION_NAME
,      LOV_ATTRIBUTE_APPL_ID
,      LOV_ATTRIBUTE_CODE
,      LOV_ATTRIBUTE_NAME
,      LOV_ITEM_NAME
,      BASE_REGION_APPL_ID
,      BASE_REGION_CODE
,      BASE_REGION_NAME
,      BASE_ATTRIBUTE_APPL_ID
,      BASE_ATTRIBUTE_CODE
,      BASE_ATTRIBUTE_NAME
,      BASE_ITEM_NAME
,      DIRECTION_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUIRED_FLAG
FROM APPS.AK_REGION_LOV_RELATIONS_V;

Dependencies

[top of page]

APPS.AK_REGION_LOV_RELATIONS_V references the following:

APPS: AK_REGIONS_VL; AK_REGION_ITEMS_VL; AK_REGION_LOV_RELATIONS

APPS.AK_REGION_LOV_RELATIONS_V is not referenced by any database object