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

TABLE: AK.AK_REGION_LOV_RELATIONS

Object Details
Object Name: AK_REGION_LOV_RELATIONS
Object Type: TABLE
Owner: AK
FND Design Data: TableAK.AK_REGION_LOV_RELATIONS
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: SYS_C00170703
  1. ColumnREGION_APPLICATION_ID
  2. ColumnREGION_CODE
  3. ColumnATTRIBUTE_APPLICATION_ID
  4. ColumnATTRIBUTE_CODE
  5. ColumnLOV_REGION_APPL_ID
  6. ColumnLOV_REGION_CODE
  7. ColumnLOV_ATTRIBUTE_APPL_ID
  8. ColumnLOV_ATTRIBUTE_CODE
  9. ColumnBASE_REGION_APPL_ID
  10. ColumnBASE_REGION_CODE
  11. ColumnBASE_ATTRIBUTE_APPL_ID
  12. ColumnBASE_ATTRIBUTE_CODE
  13. ColumnDIRECTION_FLAG
Indexes
Index Type Uniqueness Tablespace Column
AK_REGION_LOV_RELATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREGION_APPLICATION_ID
ColumnREGION_CODE
ColumnATTRIBUTE_APPLICATION_ID
ColumnATTRIBUTE_CODE
ColumnLOV_REGION_APPL_ID
ColumnLOV_REGION_CODE
ColumnLOV_ATTRIBUTE_APPL_ID
ColumnLOV_ATTRIBUTE_CODE
ColumnBASE_REGION_APPL_ID
ColumnBASE_REGION_CODE
ColumnBASE_ATTRIBUTE_APPL_ID
ColumnBASE_ATTRIBUTE_CODE
ColumnDIRECTION_FLAG
Columns
Name Datatype Length Mandatory Comments
REGION_APPLICATION_ID NUMBER
Yes Region Application Id of the region item which launches the LOV
REGION_CODE VARCHAR2 (30) Yes Region Code 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
LOV_REGION_APPL_ID NUMBER
Yes Region Application ID of LOV Region
LOV_REGION_CODE VARCHAR2 (30) Yes Region code 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
BASE_REGION_APPL_ID NUMBER
Yes Product team's application ID which the Base Region belongs to
BASE_REGION_CODE VARCHAR2 (30) Yes Base Region Identifier
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.
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 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
FROM AK.AK_REGION_LOV_RELATIONS;

Dependencies

[top of page]

AK.AK_REGION_LOV_RELATIONS does not reference any database object

AK.AK_REGION_LOV_RELATIONS is referenced by following:

SchemaAPPS
SynonymAK_REGION_LOV_RELATIONS