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

TABLE: JTF.JTY_WEBADI_OTH_TERR_INTF

Object Details
Object Name: JTY_WEBADI_OTH_TERR_INTF
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTY_WEBADI_OTH_TERR_INTF
Subobject Name:
Status: VALID


Interface table to store data that needs to be displayed in Excel


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTY_WEBADI_OTH_TERR_INTF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAY_SEQ_NUM
ColumnUSER_SEQUENCE
ColumnHEADER
ColumnINTERFACE_TYPE
ColumnACTION_FLAG
Columns
Name Datatype Length Mandatory Comments
LAY_SEQ_NUM NUMBER

Unique identifier for upload
ROW_ID NUMBER

row id
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY VARCHAR2 (30)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY VARCHAR2 (30)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
INTERFACE_TYPE VARCHAR2 (1)
Indicate whether the row is upload or download
HEADER VARCHAR2 (15)
Indicate whether the row is territory definition, resource or matching attribute
ACTION_FLAG VARCHAR2 (1)
Indicate whether the action is create, delete or update
USER_SEQUENCE NUMBER

sequence number generated each time during download
USER_ID NUMBER

User who performs the download (foreign key to FND_USER.USER_ID)
ORG_ID NUMBER

Organization identifier
ORG_NAME VARCHAR2 (360)
Organization identifier
USAGE_ID NUMBER

Usage identifier
TERR_ID NUMBER

foreign key to JTF_TERR_ALL.TERR_ID
TERR_NAME VARCHAR2 (2000)
foreign key to JTF_TERR_ALL.NAME
TERR_TYPE_ID NUMBER

foreign key to JTF_TERR_ALL.TERRITORY_TYPE_ID
TERR_TYPE_NAME VARCHAR2 (360)
foreign key to JTF_TERR_TYPES_ALL.NAME
RANK NUMBER

foreign key to JTF_TERR_ALL.RANK
NUM_WINNERS NUMBER

foreign key to JTF_TERR_ALL.NUM_WINNERS
REQUEST_ID NUMBER

Not used
TERR_START_DATE DATE

foreign key to JTF_TERR_ALL.START_DATE_ACTIVE
TERR_END_DATE DATE

foreign key to JTF_TERR_ALL.END_DATE_ACTIVE
PARENT_TERR_ID NUMBER

foreign key to JTF_TERR_ALL.PARENT_TERRITORY_ID
PARENT_TERR_NAME VARCHAR2 (2000)
foreign key to JTF_TERR_ALL.NAME
HIERARCHY VARCHAR2 (2000)
Hierarchy
TERR_RSC_ID NUMBER

foreign key to JTF_TERR_RSC_ALL.TERR_RSC_ID
STATUS VARCHAR2 (15)
Status of the upload
ERROR_CODE VARCHAR2 (255)
Not used
ERROR_MSG VARCHAR2 (2000)
Error message for upload
TERR_QUAL_ID1 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID2 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID3 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID4 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID5 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID6 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID7 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID8 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID9 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID10 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID11 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID12 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID13 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID14 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID15 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID16 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID17 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID18 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID19 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID20 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID21 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID22 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID23 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID24 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
TERR_QUAL_ID25 NUMBER

foreign key to JTF_TERR_QUAL_ALL.TERR_QUAL_ID
QUAL1_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL2_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL3_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL4_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL5_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL6_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL7_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL8_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL9_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL10_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL11_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL12_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL13_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL14_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL15_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL16_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL17_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL18_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL19_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL20_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL21_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL22_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL23_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL24_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL25_VALUE_ID NUMBER

foreign key to JTF_TERR_VALUES_ALL.TERR_VALUE_ID
QUAL1_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL1_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL1_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL1_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL2_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL2_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL2_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL2_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL3_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL3_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL3_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL3_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL4_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL4_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL4_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL4_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL5_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL5_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL5_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL5_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL6_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL6_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL6_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL6_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL7_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL7_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL7_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL7_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL8_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL8_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL8_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL8_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL9_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL9_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL9_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL9_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL10_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL10_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL10_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL10_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL11_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL11_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL11_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL11_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL12_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL12_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL12_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL12_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL13_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL13_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL13_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL13_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL14_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL14_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL14_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL14_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL15_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL15_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL15_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL15_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL16_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL16_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL16_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL16_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL17_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL17_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL17_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL17_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL18_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL18_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL18_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL18_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL19_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL19_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL19_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL19_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL20_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL20_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL20_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL20_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL21_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL21_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL21_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL21_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL22_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL22_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL22_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL22_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL23_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL23_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL23_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL23_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL24_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL24_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL24_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL24_VALUE4 VARCHAR2 (360)
Matching attributes value
QUAL25_VALUE1 VARCHAR2 (360)
Matching attributes value
QUAL25_VALUE2 VARCHAR2 (360)
Matching attributes value
QUAL25_VALUE3 VARCHAR2 (360)
Matching attributes value
QUAL25_VALUE4 VARCHAR2 (360)
Matching attributes value
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment column.
Query Text

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


SELECT LAY_SEQ_NUM
,      ROW_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INTERFACE_TYPE
,      HEADER
,      ACTION_FLAG
,      USER_SEQUENCE
,      USER_ID
,      ORG_ID
,      ORG_NAME
,      USAGE_ID
,      TERR_ID
,      TERR_NAME
,      TERR_TYPE_ID
,      TERR_TYPE_NAME
,      RANK
,      NUM_WINNERS
,      REQUEST_ID
,      TERR_START_DATE
,      TERR_END_DATE
,      PARENT_TERR_ID
,      PARENT_TERR_NAME
,      HIERARCHY
,      TERR_RSC_ID
,      STATUS
,      ERROR_CODE
,      ERROR_MSG
,      TERR_QUAL_ID1
,      TERR_QUAL_ID2
,      TERR_QUAL_ID3
,      TERR_QUAL_ID4
,      TERR_QUAL_ID5
,      TERR_QUAL_ID6
,      TERR_QUAL_ID7
,      TERR_QUAL_ID8
,      TERR_QUAL_ID9
,      TERR_QUAL_ID10
,      TERR_QUAL_ID11
,      TERR_QUAL_ID12
,      TERR_QUAL_ID13
,      TERR_QUAL_ID14
,      TERR_QUAL_ID15
,      TERR_QUAL_ID16
,      TERR_QUAL_ID17
,      TERR_QUAL_ID18
,      TERR_QUAL_ID19
,      TERR_QUAL_ID20
,      TERR_QUAL_ID21
,      TERR_QUAL_ID22
,      TERR_QUAL_ID23
,      TERR_QUAL_ID24
,      TERR_QUAL_ID25
,      QUAL1_VALUE_ID
,      QUAL2_VALUE_ID
,      QUAL3_VALUE_ID
,      QUAL4_VALUE_ID
,      QUAL5_VALUE_ID
,      QUAL6_VALUE_ID
,      QUAL7_VALUE_ID
,      QUAL8_VALUE_ID
,      QUAL9_VALUE_ID
,      QUAL10_VALUE_ID
,      QUAL11_VALUE_ID
,      QUAL12_VALUE_ID
,      QUAL13_VALUE_ID
,      QUAL14_VALUE_ID
,      QUAL15_VALUE_ID
,      QUAL16_VALUE_ID
,      QUAL17_VALUE_ID
,      QUAL18_VALUE_ID
,      QUAL19_VALUE_ID
,      QUAL20_VALUE_ID
,      QUAL21_VALUE_ID
,      QUAL22_VALUE_ID
,      QUAL23_VALUE_ID
,      QUAL24_VALUE_ID
,      QUAL25_VALUE_ID
,      QUAL1_VALUE1
,      QUAL1_VALUE2
,      QUAL1_VALUE3
,      QUAL1_VALUE4
,      QUAL2_VALUE1
,      QUAL2_VALUE2
,      QUAL2_VALUE3
,      QUAL2_VALUE4
,      QUAL3_VALUE1
,      QUAL3_VALUE2
,      QUAL3_VALUE3
,      QUAL3_VALUE4
,      QUAL4_VALUE1
,      QUAL4_VALUE2
,      QUAL4_VALUE3
,      QUAL4_VALUE4
,      QUAL5_VALUE1
,      QUAL5_VALUE2
,      QUAL5_VALUE3
,      QUAL5_VALUE4
,      QUAL6_VALUE1
,      QUAL6_VALUE2
,      QUAL6_VALUE3
,      QUAL6_VALUE4
,      QUAL7_VALUE1
,      QUAL7_VALUE2
,      QUAL7_VALUE3
,      QUAL7_VALUE4
,      QUAL8_VALUE1
,      QUAL8_VALUE2
,      QUAL8_VALUE3
,      QUAL8_VALUE4
,      QUAL9_VALUE1
,      QUAL9_VALUE2
,      QUAL9_VALUE3
,      QUAL9_VALUE4
,      QUAL10_VALUE1
,      QUAL10_VALUE2
,      QUAL10_VALUE3
,      QUAL10_VALUE4
,      QUAL11_VALUE1
,      QUAL11_VALUE2
,      QUAL11_VALUE3
,      QUAL11_VALUE4
,      QUAL12_VALUE1
,      QUAL12_VALUE2
,      QUAL12_VALUE3
,      QUAL12_VALUE4
,      QUAL13_VALUE1
,      QUAL13_VALUE2
,      QUAL13_VALUE3
,      QUAL13_VALUE4
,      QUAL14_VALUE1
,      QUAL14_VALUE2
,      QUAL14_VALUE3
,      QUAL14_VALUE4
,      QUAL15_VALUE1
,      QUAL15_VALUE2
,      QUAL15_VALUE3
,      QUAL15_VALUE4
,      QUAL16_VALUE1
,      QUAL16_VALUE2
,      QUAL16_VALUE3
,      QUAL16_VALUE4
,      QUAL17_VALUE1
,      QUAL17_VALUE2
,      QUAL17_VALUE3
,      QUAL17_VALUE4
,      QUAL18_VALUE1
,      QUAL18_VALUE2
,      QUAL18_VALUE3
,      QUAL18_VALUE4
,      QUAL19_VALUE1
,      QUAL19_VALUE2
,      QUAL19_VALUE3
,      QUAL19_VALUE4
,      QUAL20_VALUE1
,      QUAL20_VALUE2
,      QUAL20_VALUE3
,      QUAL20_VALUE4
,      QUAL21_VALUE1
,      QUAL21_VALUE2
,      QUAL21_VALUE3
,      QUAL21_VALUE4
,      QUAL22_VALUE1
,      QUAL22_VALUE2
,      QUAL22_VALUE3
,      QUAL22_VALUE4
,      QUAL23_VALUE1
,      QUAL23_VALUE2
,      QUAL23_VALUE3
,      QUAL23_VALUE4
,      QUAL24_VALUE1
,      QUAL24_VALUE2
,      QUAL24_VALUE3
,      QUAL24_VALUE4
,      QUAL25_VALUE1
,      QUAL25_VALUE2
,      QUAL25_VALUE3
,      QUAL25_VALUE4
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM JTF.JTY_WEBADI_OTH_TERR_INTF;

Dependencies

[top of page]

JTF.JTY_WEBADI_OTH_TERR_INTF does not reference any database object

JTF.JTY_WEBADI_OTH_TERR_INTF is referenced by following:

SchemaAPPS
SynonymJTY_WEBADI_OTH_TERR_INTF