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

VIEW: AK.AK_REGION_LOV_RELATIONS#

Object Details
Object Name: AK_REGION_LOV_RELATIONS#
Object Type: VIEW
Owner: AK
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REGION_APPLICATION_ID NUMBER
Yes
REGION_CODE VARCHAR2 (30) Yes
ATTRIBUTE_APPLICATION_ID NUMBER
Yes
ATTRIBUTE_CODE VARCHAR2 (30) Yes
LOV_REGION_APPL_ID NUMBER
Yes
LOV_REGION_CODE VARCHAR2 (30) Yes
LOV_ATTRIBUTE_APPL_ID NUMBER
Yes
LOV_ATTRIBUTE_CODE VARCHAR2 (30) Yes
BASE_REGION_APPL_ID NUMBER
Yes
BASE_REGION_CODE VARCHAR2 (30) Yes
BASE_ATTRIBUTE_APPL_ID NUMBER
Yes
BASE_ATTRIBUTE_CODE VARCHAR2 (30) Yes
DIRECTION_FLAG VARCHAR2 (30) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
REQUIRED_FLAG VARCHAR2 (1) Yes
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT REGION_APPLICATION_ID
,      REGION_CODE
,      ATTRIBUTE_APPLICATION_ID
,      ATTRIBUTE_CODE
,      LOV_REGION_APPL_ID
,      LOV_REGION_CODE
,      LOV_ATTRIBUTE_APPL_ID
,      LOV_ATTRIBUTE_CODE
,      BASE_REGION_APPL_ID
,      BASE_REGION_CODE
,      BASE_ATTRIBUTE_APPL_ID
,      BASE_ATTRIBUTE_CODE
,      DIRECTION_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUIRED_FLAG
,      ZD_EDITION_NAME
FROM AK.AK_REGION_LOV_RELATIONS#;

Dependencies

[top of page]

AK.AK_REGION_LOV_RELATIONS# references the following:

SchemaAK
TableAK_REGION_LOV_RELATIONS
AK.AK_REGION_LOV_RELATIONS# is referenced by following:

SchemaAPPS
SynonymAK_REGION_LOV_RELATIONS
TriggerAK_REGION_LOV_RELATIONS+