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

VIEW: JTM.JTM_AK_REGION_LOV_REL_ACC#

Object Details
Object Name: JTM_AK_REGION_LOV_REL_ACC#
Object Type: VIEW
Owner: JTM
Subobject Name:
Status: VALID

[View Source]

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

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


SELECT ACCESS_ID
,      ATTRIBUTE_APPLICATION_ID
,      ATTRIBUTE_CODE
,      BASE_ATTRIBUTE_APPL_ID
,      BASE_ATTRIBUTE_CODE
,      BASE_REGION_APPL_ID
,      BASE_REGION_CODE
,      DIRECTION_FLAG
,      LOV_ATTRIBUTE_APPL_ID
,      LOV_ATTRIBUTE_CODE
,      LOV_REGION_APPL_ID
,      LOV_REGION_CODE
,      REGION_APPLICATION_ID
,      REGION_CODE
,      COUNTER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM JTM.JTM_AK_REGION_LOV_REL_ACC#;

Dependencies

[top of page]

JTM.JTM_AK_REGION_LOV_REL_ACC# references the following:

SchemaJTM
TableJTM_AK_REGION_LOV_REL_ACC
JTM.JTM_AK_REGION_LOV_REL_ACC# is referenced by following:

SchemaAPPS
SynonymJTM_AK_REGION_LOV_REL_ACC