[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JTY_WEBADI_OTH_TERR_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  JTF.JTY_WEBADI_OTH_TERR_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for Other Territories Excel Download
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CREATION_DATE | DATE | Creation Date | ||
| LAST_UPDATE_DATE | DATE | Last Update Date | ||
| LAST_UPDATED_BY | VARCHAR2 | (30) | Last Updated By | |
| CREATED_BY | VARCHAR2 | (30) | Created By | |
| LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
| INTERFACE_TYPE | VARCHAR2 | (1) | Interface Type | |
| HEADER | VARCHAR2 | (15) | Header | |
| ACTION_FLAG | VARCHAR2 | (1) | Action Flag | |
| USER_SEQUENCE | NUMBER | User Sequence | ||
| USER_ID | NUMBER | User Id | ||
| ORG_ID | NUMBER | Org Id | ||
| ORG_NAME | VARCHAR2 | (360) | Org Name | |
| USAGE_ID | NUMBER | Usage Id | ||
| TERR_ID | NUMBER | Terr Id | ||
| TERR_NAME | VARCHAR2 | (2000) | Terr Name | |
| TERR_TYPE_ID | NUMBER | Terr Type Id | ||
| TERR_TYPE_NAME | VARCHAR2 | (360) | Terr Type Name | |
| RANK | NUMBER | Rank | ||
| NUM_WINNERS | NUMBER | Num Winners | ||
| TERR_START_DATE | DATE | Terr Start Date | ||
| TERR_END_DATE | DATE | Terr End Date | ||
| PARENT_TERR_ID | NUMBER | Parent Terr Id | ||
| PARENT_TERR_NAME | VARCHAR2 | (2000) | Parent Terr Name | |
| HIERARCHY | VARCHAR2 | (2000) | Hierarchy | |
| QUAL1_VALUE_ID | NUMBER | Qual1 Value Id | ||
| QUAL2_VALUE_ID | NUMBER | Qual2 Value Id | ||
| QUAL3_VALUE_ID | NUMBER | Qual3 Value Id | ||
| QUAL4_VALUE_ID | NUMBER | Qual4 Value Id | ||
| QUAL5_VALUE_ID | NUMBER | Qual5 Value Id | ||
| QUAL6_VALUE_ID | NUMBER | Qual6 Value Id | ||
| QUAL7_VALUE_ID | NUMBER | Qual7 Value Id | ||
| QUAL8_VALUE_ID | NUMBER | Qual8 Value Id | ||
| QUAL9_VALUE_ID | NUMBER | Qual9 Value Id | ||
| QUAL10_VALUE_ID | NUMBER | Qual10 Value Id | ||
| QUAL11_VALUE_ID | NUMBER | Qual11 Value Id | ||
| QUAL12_VALUE_ID | NUMBER | Qual12 Value Id | ||
| QUAL13_VALUE_ID | NUMBER | Qual13 Value Id | ||
| QUAL14_VALUE_ID | NUMBER | Qual14 Value Id | ||
| QUAL15_VALUE_ID | NUMBER | Qual15 Value Id | ||
| QUAL16_VALUE_ID | NUMBER | Qual16 Value Id | ||
| QUAL17_VALUE_ID | NUMBER | Qual17 Value Id | ||
| QUAL18_VALUE_ID | NUMBER | Qual18 Value Id | ||
| QUAL19_VALUE_ID | NUMBER | Qual19 Value Id | ||
| QUAL20_VALUE_ID | NUMBER | Qual20 Value Id | ||
| QUAL21_VALUE_ID | NUMBER | Qual21 Value Id | ||
| QUAL22_VALUE_ID | NUMBER | Qual22 Value Id | ||
| QUAL23_VALUE_ID | NUMBER | Qual23 Value Id | ||
| QUAL24_VALUE_ID | NUMBER | Qual24 Value Id | ||
| QUAL25_VALUE_ID | NUMBER | Qual25 Value Id | ||
| QUAL1_VALUE1 | VARCHAR2 | (360) | Qual1 Value1 | |
| QUAL2_VALUE1 | VARCHAR2 | (360) | Qual2 Value1 | |
| QUAL3_VALUE1 | VARCHAR2 | (360) | Qual3 Value1 | |
| QUAL4_VALUE1 | VARCHAR2 | (360) | Qual4 Value1 | |
| QUAL5_VALUE1 | VARCHAR2 | (360) | Qual5 Value1 | |
| QUAL6_VALUE1 | VARCHAR2 | (360) | Qual6 Value1 | |
| QUAL7_VALUE1 | VARCHAR2 | (360) | Qual7 Value1 | |
| QUAL8_VALUE1 | VARCHAR2 | (360) | Qual8 Value1 | |
| QUAL9_VALUE1 | VARCHAR2 | (360) | Qual9 Value1 | |
| QUAL10_VALUE1 | VARCHAR2 | (360) | Qual10 Value1 | |
| QUAL11_VALUE1 | VARCHAR2 | (360) | Qual11 Value1 | |
| QUAL12_VALUE1 | VARCHAR2 | (360) | Qual12 Value1 | |
| QUAL13_VALUE1 | VARCHAR2 | (360) | Qual13 Value1 | |
| QUAL14_VALUE1 | VARCHAR2 | (360) | Qual14 Value1 | |
| QUAL15_VALUE1 | VARCHAR2 | (360) | Qual15 Value1 | |
| QUAL16_VALUE1 | VARCHAR2 | (360) | Qual16 Value1 | |
| QUAL17_VALUE1 | VARCHAR2 | (360) | Qual17 Value1 | |
| QUAL18_VALUE1 | VARCHAR2 | (360) | Qual18 Value1 | |
| QUAL19_VALUE1 | VARCHAR2 | (360) | Qual19 Value1 | |
| QUAL20_VALUE1 | VARCHAR2 | (360) | Qual20 Value1 | |
| QUAL21_VALUE1 | VARCHAR2 | (360) | Qual21 Value1 | |
| QUAL22_VALUE1 | VARCHAR2 | (360) | Qual22 Value1 | |
| QUAL23_VALUE1 | VARCHAR2 | (360) | Qual23 Value1 | |
| QUAL24_VALUE1 | VARCHAR2 | (360) | Qual24 Value1 | |
| QUAL25_VALUE1 | VARCHAR2 | (360) | Qual25 Value1 | |
| QUAL1_VALUE2 | VARCHAR2 | (360) | Qual1 Value2 | |
| QUAL2_VALUE2 | VARCHAR2 | (360) | Qual2 Value2 | |
| QUAL3_VALUE2 | VARCHAR2 | (360) | Qual3 Value2 | |
| QUAL4_VALUE2 | VARCHAR2 | (360) | Qual4 Value2 | |
| QUAL5_VALUE2 | VARCHAR2 | (360) | Qual5 Value2 | |
| QUAL6_VALUE2 | VARCHAR2 | (360) | Qual6 Value2 | |
| QUAL7_VALUE2 | VARCHAR2 | (360) | Qual7 Value2 | |
| QUAL8_VALUE2 | VARCHAR2 | (360) | Qual8 Value2 | |
| QUAL9_VALUE2 | VARCHAR2 | (360) | Qual9 Value2 | |
| QUAL10_VALUE2 | VARCHAR2 | (360) | Qual10 Value2 | |
| QUAL11_VALUE2 | VARCHAR2 | (360) | Qual11 Value2 | |
| QUAL12_VALUE2 | VARCHAR2 | (360) | Qual12 Value2 | |
| QUAL13_VALUE2 | VARCHAR2 | (360) | Qual13 Value2 | |
| QUAL14_VALUE2 | VARCHAR2 | (360) | Qual14 Value2 | |
| QUAL15_VALUE2 | VARCHAR2 | (360) | Qual15 Value2 | |
| QUAL16_VALUE2 | VARCHAR2 | (360) | Qual16 Value2 | |
| QUAL17_VALUE2 | VARCHAR2 | (360) | Qual17 Value2 | |
| QUAL18_VALUE2 | VARCHAR2 | (360) | Qual18 Value2 | |
| QUAL19_VALUE2 | VARCHAR2 | (360) | Qual19 Value2 | |
| QUAL20_VALUE2 | VARCHAR2 | (360) | Qual20 Value2 | |
| QUAL21_VALUE2 | VARCHAR2 | (360) | Qual21 Value2 | |
| QUAL22_VALUE2 | VARCHAR2 | (360) | Qual22 Value2 | |
| QUAL23_VALUE2 | VARCHAR2 | (360) | Qual23 Value2 | |
| QUAL24_VALUE2 | VARCHAR2 | (360) | Qual24 Value2 | |
| QUAL25_VALUE2 | VARCHAR2 | (360) | Qual25 Value2 | |
| QUAL1_VALUE3 | VARCHAR2 | (360) | Qual1 Value3 | |
| QUAL2_VALUE3 | VARCHAR2 | (360) | Qual2 Value3 | |
| QUAL3_VALUE3 | VARCHAR2 | (360) | Qual3 Value3 | |
| QUAL4_VALUE3 | VARCHAR2 | (360) | Qual4 Value3 | |
| QUAL5_VALUE3 | VARCHAR2 | (360) | Qual5 Value3 | |
| QUAL6_VALUE3 | VARCHAR2 | (360) | Qual6 Value3 | |
| QUAL7_VALUE3 | VARCHAR2 | (360) | Qual7 Value3 | |
| QUAL8_VALUE3 | VARCHAR2 | (360) | Qual8 Value3 | |
| QUAL9_VALUE3 | VARCHAR2 | (360) | Qual9 Value3 | |
| QUAL10_VALUE3 | VARCHAR2 | (360) | Qual10 Value3 | |
| QUAL11_VALUE3 | VARCHAR2 | (360) | Qual11 Value3 | |
| QUAL12_VALUE3 | VARCHAR2 | (360) | Qual12 Value3 | |
| QUAL13_VALUE3 | VARCHAR2 | (360) | Qual13 Value3 | |
| QUAL14_VALUE3 | VARCHAR2 | (360) | Qual14 Value3 | |
| QUAL15_VALUE3 | VARCHAR2 | (360) | Qual15 Value3 | |
| QUAL16_VALUE3 | VARCHAR2 | (360) | Qual16 Value3 | |
| QUAL17_VALUE3 | VARCHAR2 | (360) | Qual17 Value3 | |
| QUAL18_VALUE3 | VARCHAR2 | (360) | Qual18 Value3 | |
| QUAL19_VALUE3 | VARCHAR2 | (360) | Qual19 Value3 | |
| QUAL20_VALUE3 | VARCHAR2 | (360) | Qual20 Value3 | |
| QUAL21_VALUE3 | VARCHAR2 | (360) | Qual21 Value3 | |
| QUAL22_VALUE3 | VARCHAR2 | (360) | Qual22 Value3 | |
| QUAL23_VALUE3 | VARCHAR2 | (360) | Qual23 Value3 | |
| QUAL24_VALUE3 | VARCHAR2 | (360) | Qual24 Value3 | |
| QUAL25_VALUE3 | VARCHAR2 | (360) | Qual25 Value3 | |
| QUAL1_VALUE4 | VARCHAR2 | (360) | Qual1 Value4 | |
| QUAL2_VALUE4 | VARCHAR2 | (360) | Qual2 Value4 | |
| QUAL3_VALUE4 | VARCHAR2 | (360) | Qual3 Value4 | |
| QUAL4_VALUE4 | VARCHAR2 | (360) | Qual4 Value4 | |
| QUAL5_VALUE4 | VARCHAR2 | (360) | Qual5 Value4 | |
| QUAL6_VALUE4 | VARCHAR2 | (360) | Qual6 Value4 | |
| QUAL7_VALUE4 | VARCHAR2 | (360) | Qual7 Value4 | |
| QUAL8_VALUE4 | VARCHAR2 | (360) | Qual8 Value4 | |
| QUAL9_VALUE4 | VARCHAR2 | (360) | Qual9 Value4 | |
| QUAL10_VALUE4 | VARCHAR2 | (360) | Qual10 Value4 | |
| QUAL11_VALUE4 | VARCHAR2 | (360) | Qual11 Value4 | |
| QUAL12_VALUE4 | VARCHAR2 | (360) | Qual12 Value4 | |
| QUAL13_VALUE4 | VARCHAR2 | (360) | Qual13 Value4 | |
| QUAL14_VALUE4 | VARCHAR2 | (360) | Qual14 Value4 | |
| QUAL15_VALUE4 | VARCHAR2 | (360) | Qual15 Value4 | |
| QUAL16_VALUE4 | VARCHAR2 | (360) | Qual16 Value4 | |
| QUAL17_VALUE4 | VARCHAR2 | (360) | Qual17 Value4 | |
| QUAL18_VALUE4 | VARCHAR2 | (360) | Qual18 Value4 | |
| QUAL19_VALUE4 | VARCHAR2 | (360) | Qual19 Value4 | |
| QUAL20_VALUE4 | VARCHAR2 | (360) | Qual20 Value4 | |
| QUAL21_VALUE4 | VARCHAR2 | (360) | Qual21 Value4 | |
| QUAL22_VALUE4 | VARCHAR2 | (360) | Qual22 Value4 | |
| QUAL23_VALUE4 | VARCHAR2 | (360) | Qual23 Value4 | |
| QUAL24_VALUE4 | VARCHAR2 | (360) | Qual24 Value4 | |
| QUAL25_VALUE4 | VARCHAR2 | (360) | Qual25 Value4 | |
| QUAL26_VALUE_ID | NUMBER | |||
| QUAL26_VALUE1 | VARCHAR2 | (360) | ||
| QUAL26_VALUE2 | VARCHAR2 | (360) | ||
| QUAL26_VALUE3 | VARCHAR2 | (360) | ||
| QUAL27_VALUE_ID | NUMBER | |||
| QUAL27_VALUE1 | VARCHAR2 | (360) | ||
| QUAL27_VALUE2 | VARCHAR2 | (360) | ||
| QUAL27_VALUE3 | VARCHAR2 | (360) | ||
| QUAL28_VALUE_ID | NUMBER | |||
| QUAL28_VALUE1 | VARCHAR2 | (360) | ||
| QUAL28_VALUE2 | VARCHAR2 | (360) | ||
| QUAL28_VALUE3 | VARCHAR2 | (360) | ||
| QUAL29_VALUE_ID | NUMBER | |||
| QUAL29_VALUE1 | VARCHAR2 | (360) | ||
| QUAL29_VALUE2 | VARCHAR2 | (360) | ||
| QUAL29_VALUE3 | VARCHAR2 | (360) | ||
| QUAL30_VALUE_ID | NUMBER | |||
| QUAL30_VALUE1 | VARCHAR2 | (360) | ||
| QUAL30_VALUE2 | VARCHAR2 | (360) | ||
| QUAL30_VALUE3 | VARCHAR2 | (360) | ||
| QUAL31_VALUE_ID | NUMBER | |||
| QUAL31_VALUE1 | VARCHAR2 | (360) | ||
| QUAL31_VALUE2 | VARCHAR2 | (360) | ||
| QUAL31_VALUE3 | VARCHAR2 | (360) | ||
| QUAL32_VALUE_ID | NUMBER | |||
| QUAL32_VALUE1 | VARCHAR2 | (360) | ||
| QUAL32_VALUE2 | VARCHAR2 | (360) | ||
| QUAL32_VALUE3 | VARCHAR2 | (360) | ||
| QUAL33_VALUE_ID | NUMBER | |||
| QUAL33_VALUE1 | VARCHAR2 | (360) | ||
| QUAL33_VALUE2 | VARCHAR2 | (360) | ||
| QUAL33_VALUE3 | VARCHAR2 | (360) | ||
| QUAL34_VALUE_ID | NUMBER | |||
| QUAL34_VALUE1 | VARCHAR2 | (360) | ||
| QUAL34_VALUE2 | VARCHAR2 | (360) | ||
| QUAL34_VALUE3 | VARCHAR2 | (360) | ||
| QUAL35_VALUE_ID | NUMBER | |||
| QUAL35_VALUE1 | VARCHAR2 | (360) | ||
| QUAL35_VALUE2 | VARCHAR2 | (360) | ||
| QUAL35_VALUE3 | VARCHAR2 | (360) | ||
| QUAL36_VALUE_ID | NUMBER | |||
| QUAL36_VALUE1 | VARCHAR2 | (360) | ||
| QUAL36_VALUE2 | VARCHAR2 | (360) | ||
| QUAL36_VALUE3 | VARCHAR2 | (360) | ||
| QUAL37_VALUE_ID | NUMBER | |||
| QUAL37_VALUE1 | VARCHAR2 | (360) | ||
| QUAL37_VALUE2 | VARCHAR2 | (360) | ||
| QUAL37_VALUE3 | VARCHAR2 | (360) | ||
| QUAL38_VALUE_ID | NUMBER | |||
| QUAL38_VALUE1 | VARCHAR2 | (360) | ||
| QUAL38_VALUE2 | VARCHAR2 | (360) | ||
| QUAL38_VALUE3 | VARCHAR2 | (360) | ||
| QUAL39_VALUE_ID | NUMBER | |||
| QUAL39_VALUE1 | VARCHAR2 | (360) | ||
| QUAL39_VALUE2 | VARCHAR2 | (360) | ||
| QUAL39_VALUE3 | VARCHAR2 | (360) | ||
| QUAL40_VALUE_ID | NUMBER | |||
| QUAL40_VALUE1 | VARCHAR2 | (360) | ||
| QUAL40_VALUE2 | VARCHAR2 | (360) | ||
| QUAL40_VALUE3 | VARCHAR2 | (360) | ||
| QUAL41_VALUE_ID | NUMBER | |||
| QUAL41_VALUE1 | VARCHAR2 | (360) | ||
| QUAL41_VALUE2 | VARCHAR2 | (360) | ||
| QUAL41_VALUE3 | VARCHAR2 | (360) | ||
| QUAL42_VALUE_ID | NUMBER | |||
| QUAL42_VALUE1 | VARCHAR2 | (360) | ||
| QUAL42_VALUE2 | VARCHAR2 | (360) | ||
| QUAL42_VALUE3 | VARCHAR2 | (360) | ||
| QUAL43_VALUE_ID | NUMBER | |||
| QUAL43_VALUE1 | VARCHAR2 | (360) | ||
| QUAL43_VALUE2 | VARCHAR2 | (360) | ||
| QUAL43_VALUE3 | VARCHAR2 | (360) | ||
| QUAL44_VALUE_ID | NUMBER | |||
| QUAL44_VALUE1 | VARCHAR2 | (360) | ||
| QUAL44_VALUE2 | VARCHAR2 | (360) | ||
| QUAL44_VALUE3 | VARCHAR2 | (360) | ||
| QUAL45_VALUE_ID | NUMBER | |||
| QUAL45_VALUE1 | VARCHAR2 | (360) | ||
| QUAL45_VALUE2 | VARCHAR2 | (360) | ||
| QUAL45_VALUE3 | VARCHAR2 | (360) | ||
| QUAL46_VALUE_ID | NUMBER | |||
| QUAL46_VALUE1 | VARCHAR2 | (360) | ||
| QUAL46_VALUE2 | VARCHAR2 | (360) | ||
| QUAL46_VALUE3 | VARCHAR2 | (360) | ||
| QUAL47_VALUE_ID | NUMBER | |||
| QUAL47_VALUE1 | VARCHAR2 | (360) | ||
| QUAL47_VALUE2 | VARCHAR2 | (360) | ||
| QUAL47_VALUE3 | VARCHAR2 | (360) | ||
| QUAL48_VALUE_ID | NUMBER | |||
| QUAL48_VALUE1 | VARCHAR2 | (360) | ||
| QUAL48_VALUE2 | VARCHAR2 | (360) | ||
| QUAL48_VALUE3 | VARCHAR2 | (360) | ||
| QUAL49_VALUE_ID | NUMBER | |||
| QUAL49_VALUE1 | VARCHAR2 | (360) | ||
| QUAL49_VALUE2 | VARCHAR2 | (360) | ||
| QUAL49_VALUE3 | VARCHAR2 | (360) | ||
| QUAL50_VALUE_ID | NUMBER | |||
| QUAL50_VALUE1 | VARCHAR2 | (360) | ||
| QUAL50_VALUE2 | VARCHAR2 | (360) | ||
| QUAL50_VALUE3 | VARCHAR2 | (360) | ||
| QUAL51_VALUE_ID | NUMBER | |||
| QUAL51_VALUE1 | VARCHAR2 | (360) | ||
| QUAL51_VALUE2 | VARCHAR2 | (360) | ||
| QUAL51_VALUE3 | VARCHAR2 | (360) | ||
| QUAL52_VALUE_ID | NUMBER | |||
| QUAL52_VALUE1 | VARCHAR2 | (360) | ||
| QUAL52_VALUE2 | VARCHAR2 | (360) | ||
| QUAL52_VALUE3 | VARCHAR2 | (360) | ||
| QUAL53_VALUE_ID | NUMBER | |||
| QUAL53_VALUE1 | VARCHAR2 | (360) | ||
| QUAL53_VALUE2 | VARCHAR2 | (360) | ||
| QUAL53_VALUE3 | VARCHAR2 | (360) | ||
| QUAL54_VALUE_ID | NUMBER | |||
| QUAL54_VALUE1 | VARCHAR2 | (360) | ||
| QUAL54_VALUE2 | VARCHAR2 | (360) | ||
| QUAL54_VALUE3 | VARCHAR2 | (360) | ||
| QUAL55_VALUE_ID | NUMBER | |||
| QUAL55_VALUE1 | VARCHAR2 | (360) | ||
| QUAL55_VALUE2 | VARCHAR2 | (360) | ||
| QUAL55_VALUE3 | VARCHAR2 | (360) | ||
| QUAL56_VALUE_ID | NUMBER | |||
| QUAL56_VALUE1 | VARCHAR2 | (360) | ||
| QUAL56_VALUE2 | VARCHAR2 | (360) | ||
| QUAL56_VALUE3 | VARCHAR2 | (360) | ||
| QUAL57_VALUE_ID | NUMBER | |||
| QUAL57_VALUE1 | VARCHAR2 | (360) | ||
| QUAL57_VALUE2 | VARCHAR2 | (360) | ||
| QUAL57_VALUE3 | VARCHAR2 | (360) | ||
| QUAL58_VALUE_ID | NUMBER | |||
| QUAL58_VALUE1 | VARCHAR2 | (360) | ||
| QUAL58_VALUE2 | VARCHAR2 | (360) | ||
| QUAL58_VALUE3 | VARCHAR2 | (360) | ||
| QUAL59_VALUE_ID | NUMBER | |||
| QUAL59_VALUE1 | VARCHAR2 | (360) | ||
| QUAL59_VALUE2 | VARCHAR2 | (360) | ||
| QUAL59_VALUE3 | VARCHAR2 | (360) | ||
| QUAL60_VALUE_ID | NUMBER | |||
| QUAL60_VALUE1 | VARCHAR2 | (360) | ||
| QUAL60_VALUE2 | VARCHAR2 | (360) | ||
| QUAL60_VALUE3 | VARCHAR2 | (360) | ||
| QUAL61_VALUE_ID | NUMBER | |||
| QUAL61_VALUE1 | VARCHAR2 | (360) | ||
| QUAL61_VALUE2 | VARCHAR2 | (360) | ||
| QUAL61_VALUE3 | VARCHAR2 | (360) | ||
| QUAL62_VALUE_ID | NUMBER | |||
| QUAL62_VALUE1 | VARCHAR2 | (360) | ||
| QUAL62_VALUE2 | VARCHAR2 | (360) | ||
| QUAL62_VALUE3 | VARCHAR2 | (360) | ||
| QUAL63_VALUE_ID | NUMBER | |||
| QUAL63_VALUE1 | VARCHAR2 | (360) | ||
| QUAL63_VALUE2 | VARCHAR2 | (360) | ||
| QUAL63_VALUE3 | VARCHAR2 | (360) | ||
| QUAL64_VALUE_ID | NUMBER | |||
| QUAL64_VALUE1 | VARCHAR2 | (360) | ||
| QUAL64_VALUE2 | VARCHAR2 | (360) | ||
| QUAL64_VALUE3 | VARCHAR2 | (360) | ||
| QUAL65_VALUE_ID | NUMBER | |||
| QUAL65_VALUE1 | VARCHAR2 | (360) | ||
| QUAL65_VALUE2 | VARCHAR2 | (360) | ||
| QUAL65_VALUE3 | VARCHAR2 | (360) | ||
| QUAL66_VALUE_ID | NUMBER | |||
| QUAL66_VALUE1 | VARCHAR2 | (360) | ||
| QUAL66_VALUE2 | VARCHAR2 | (360) | ||
| QUAL66_VALUE3 | VARCHAR2 | (360) | ||
| QUAL67_VALUE_ID | NUMBER | |||
| QUAL67_VALUE1 | VARCHAR2 | (360) | ||
| QUAL67_VALUE2 | VARCHAR2 | (360) | ||
| QUAL67_VALUE3 | VARCHAR2 | (360) | ||
| QUAL68_VALUE_ID | NUMBER | |||
| QUAL68_VALUE1 | VARCHAR2 | (360) | ||
| QUAL68_VALUE2 | VARCHAR2 | (360) | ||
| QUAL68_VALUE3 | VARCHAR2 | (360) | ||
| QUAL69_VALUE_ID | NUMBER | |||
| QUAL69_VALUE1 | VARCHAR2 | (360) | ||
| QUAL69_VALUE2 | VARCHAR2 | (360) | ||
| QUAL69_VALUE3 | VARCHAR2 | (360) | ||
| QUAL70_VALUE_ID | NUMBER | |||
| QUAL70_VALUE1 | VARCHAR2 | (360) | ||
| QUAL70_VALUE2 | VARCHAR2 | (360) | ||
| QUAL70_VALUE3 | VARCHAR2 | (360) | ||
| QUAL71_VALUE_ID | NUMBER | |||
| QUAL71_VALUE1 | VARCHAR2 | (360) | ||
| QUAL71_VALUE2 | VARCHAR2 | (360) | ||
| QUAL71_VALUE3 | VARCHAR2 | (360) | ||
| QUAL72_VALUE_ID | NUMBER | |||
| QUAL72_VALUE1 | VARCHAR2 | (360) | ||
| QUAL72_VALUE2 | VARCHAR2 | (360) | ||
| QUAL72_VALUE3 | VARCHAR2 | (360) | ||
| QUAL73_VALUE_ID | NUMBER | |||
| QUAL73_VALUE1 | VARCHAR2 | (360) | ||
| QUAL73_VALUE2 | VARCHAR2 | (360) | ||
| QUAL73_VALUE3 | VARCHAR2 | (360) | ||
| QUAL74_VALUE_ID | NUMBER | |||
| QUAL74_VALUE1 | VARCHAR2 | (360) | ||
| QUAL74_VALUE2 | VARCHAR2 | (360) | ||
| QUAL74_VALUE3 | VARCHAR2 | (360) | ||
| QUAL75_VALUE_ID | NUMBER | |||
| QUAL75_VALUE1 | VARCHAR2 | (360) | ||
| QUAL75_VALUE2 | VARCHAR2 | (360) | ||
| QUAL75_VALUE3 | VARCHAR2 | (360) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Attribute Category | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Attribute1 | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Attribute2 | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Attribute3 | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Attribute4 | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Attribute5 | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Attribute6 | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Attribute7 | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Attribute8 | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Attribute9 | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Attribute10 | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Attribute11 | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Attribute12 | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Attribute13 | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Attribute14 | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Attribute15 | |
| RESOURCE_TYPE | VARCHAR2 | (30) | Resource Type | |
| RESOURCE_NAME | VARCHAR2 | (360) | Resource Name | |
| RESOURCE_ID | NUMBER | Resource Id | ||
| RESOURCE_GROUP | VARCHAR2 | (360) | Resource Group | |
| GROUP_ID | NUMBER | Group Id | ||
| RESOURCE_ROLE | VARCHAR2 | (360) | Resource Role | |
| ROLE_CODE | VARCHAR2 | (360) | Role Code | |
| VARCHAR2 | (360) | |||
| RES_START_DATE | DATE | Res Start Date | ||
| RES_END_DATE | DATE | Res End Date | ||
| TERR_RSC_ACCESS_ID1 | NUMBER | Terr Rsc Access Id1 | ||
| TRANS_ACCESS_CODE1 | VARCHAR2 | (30) | Trans Access Code1 | |
| TERR_RSC_ACCESS_ID2 | NUMBER | Terr Rsc Access Id2 | ||
| TRANS_ACCESS_CODE2 | VARCHAR2 | (30) | Trans Access Code2 | |
| TERR_RSC_ACCESS_ID3 | NUMBER | Terr Rsc Access Id3 | ||
| TRANS_ACCESS_CODE3 | VARCHAR2 | (30) | Trans Access Code3 | |
| TERR_RSC_ACCESS_ID4 | NUMBER | Terr Rsc Access Id4 | ||
| TRANS_ACCESS_CODE4 | VARCHAR2 | (30) | Trans Access Code4 | |
| TERR_RSC_ACCESS_ID5 | NUMBER | Terr Rsc Access Id5 | ||
| TRANS_ACCESS_CODE5 | VARCHAR2 | (30) | Trans Access Code5 | |
| TERR_RSC_ACCESS_ID6 | NUMBER | Terr Rsc Access Id6 | ||
| TRANS_ACCESS_CODE6 | VARCHAR2 | (30) | Trans Access Code6 | |
| TERR_RSC_ACCESS_ID7 | NUMBER | Terr Rsc Access Id7 | ||
| TRANS_ACCESS_CODE7 | VARCHAR2 | (30) | Trans Access Code7 | |
| TERR_RSC_ACCESS_ID8 | NUMBER | Terr Rsc Access Id8 | ||
| TRANS_ACCESS_CODE8 | VARCHAR2 | (30) | Trans Access Code8 | |
| TERR_RSC_ACCESS_ID9 | NUMBER | Terr Rsc Access Id9 | ||
| TRANS_ACCESS_CODE9 | VARCHAR2 | (30) | Trans Access Code9 | |
| TERR_RSC_ACCESS_ID10 | NUMBER | Terr Rsc Access Id10 | ||
| TRANS_ACCESS_CODE10 | VARCHAR2 | (30) | Trans Access Code10 | |
| RSC_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Rsc Attribute Category | |
| RSC_ATTRIBUTE1 | VARCHAR2 | (150) | Rsc Attribute1 | |
| RSC_ATTRIBUTE2 | VARCHAR2 | (150) | Rsc Attribute2 | |
| RSC_ATTRIBUTE3 | VARCHAR2 | (150) | Rsc Attribute3 | |
| RSC_ATTRIBUTE4 | VARCHAR2 | (150) | Rsc Attribute4 | |
| RSC_ATTRIBUTE5 | VARCHAR2 | (150) | Rsc Attribute5 | |
| RSC_ATTRIBUTE6 | VARCHAR2 | (150) | Rsc Attribute6 | |
| RSC_ATTRIBUTE7 | VARCHAR2 | (150) | Rsc Attribute7 | |
| RSC_ATTRIBUTE8 | VARCHAR2 | (150) | Rsc Attribute8 | |
| RSC_ATTRIBUTE9 | VARCHAR2 | (150) | Rsc Attribute9 | |
| RSC_ATTRIBUTE10 | VARCHAR2 | (150) | Rsc Attribute10 | |
| RSC_ATTRIBUTE11 | VARCHAR2 | (150) | Rsc Attribute11 | |
| RSC_ATTRIBUTE12 | VARCHAR2 | (150) | Rsc Attribute12 | |
| RSC_ATTRIBUTE13 | VARCHAR2 | (150) | Rsc Attribute13 | |
| RSC_ATTRIBUTE14 | VARCHAR2 | (150) | Rsc Attribute14 | |
| RSC_ATTRIBUTE15 | VARCHAR2 | (150) | Rsc Attribute15 | |
| TERR_RSC_ID | NUMBER | Terr Rsc Id |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, TERR_START_DATE
, TERR_END_DATE
, PARENT_TERR_ID
, PARENT_TERR_NAME
, HIERARCHY
, 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
, QUAL2_VALUE1
, QUAL3_VALUE1
, QUAL4_VALUE1
, QUAL5_VALUE1
, QUAL6_VALUE1
, QUAL7_VALUE1
, QUAL8_VALUE1
, QUAL9_VALUE1
, QUAL10_VALUE1
, QUAL11_VALUE1
, QUAL12_VALUE1
, QUAL13_VALUE1
, QUAL14_VALUE1
, QUAL15_VALUE1
, QUAL16_VALUE1
, QUAL17_VALUE1
, QUAL18_VALUE1
, QUAL19_VALUE1
, QUAL20_VALUE1
, QUAL21_VALUE1
, QUAL22_VALUE1
, QUAL23_VALUE1
, QUAL24_VALUE1
, QUAL25_VALUE1
, QUAL1_VALUE2
, QUAL2_VALUE2
, QUAL3_VALUE2
, QUAL4_VALUE2
, QUAL5_VALUE2
, QUAL6_VALUE2
, QUAL7_VALUE2
, QUAL8_VALUE2
, QUAL9_VALUE2
, QUAL10_VALUE2
, QUAL11_VALUE2
, QUAL12_VALUE2
, QUAL13_VALUE2
, QUAL14_VALUE2
, QUAL15_VALUE2
, QUAL16_VALUE2
, QUAL17_VALUE2
, QUAL18_VALUE2
, QUAL19_VALUE2
, QUAL20_VALUE2
, QUAL21_VALUE2
, QUAL22_VALUE2
, QUAL23_VALUE2
, QUAL24_VALUE2
, QUAL25_VALUE2
, QUAL1_VALUE3
, QUAL2_VALUE3
, QUAL3_VALUE3
, QUAL4_VALUE3
, QUAL5_VALUE3
, QUAL6_VALUE3
, QUAL7_VALUE3
, QUAL8_VALUE3
, QUAL9_VALUE3
, QUAL10_VALUE3
, QUAL11_VALUE3
, QUAL12_VALUE3
, QUAL13_VALUE3
, QUAL14_VALUE3
, QUAL15_VALUE3
, QUAL16_VALUE3
, QUAL17_VALUE3
, QUAL18_VALUE3
, QUAL19_VALUE3
, QUAL20_VALUE3
, QUAL21_VALUE3
, QUAL22_VALUE3
, QUAL23_VALUE3
, QUAL24_VALUE3
, QUAL25_VALUE3
, QUAL1_VALUE4
, QUAL2_VALUE4
, QUAL3_VALUE4
, QUAL4_VALUE4
, QUAL5_VALUE4
, QUAL6_VALUE4
, QUAL7_VALUE4
, QUAL8_VALUE4
, QUAL9_VALUE4
, QUAL10_VALUE4
, QUAL11_VALUE4
, QUAL12_VALUE4
, QUAL13_VALUE4
, QUAL14_VALUE4
, QUAL15_VALUE4
, QUAL16_VALUE4
, QUAL17_VALUE4
, QUAL18_VALUE4
, QUAL19_VALUE4
, QUAL20_VALUE4
, QUAL21_VALUE4
, QUAL22_VALUE4
, QUAL23_VALUE4
, QUAL24_VALUE4
, QUAL25_VALUE4
, QUAL26_VALUE_ID
, QUAL26_VALUE1
, QUAL26_VALUE2
, QUAL26_VALUE3
, QUAL27_VALUE_ID
, QUAL27_VALUE1
, QUAL27_VALUE2
, QUAL27_VALUE3
, QUAL28_VALUE_ID
, QUAL28_VALUE1
, QUAL28_VALUE2
, QUAL28_VALUE3
, QUAL29_VALUE_ID
, QUAL29_VALUE1
, QUAL29_VALUE2
, QUAL29_VALUE3
, QUAL30_VALUE_ID
, QUAL30_VALUE1
, QUAL30_VALUE2
, QUAL30_VALUE3
, QUAL31_VALUE_ID
, QUAL31_VALUE1
, QUAL31_VALUE2
, QUAL31_VALUE3
, QUAL32_VALUE_ID
, QUAL32_VALUE1
, QUAL32_VALUE2
, QUAL32_VALUE3
, QUAL33_VALUE_ID
, QUAL33_VALUE1
, QUAL33_VALUE2
, QUAL33_VALUE3
, QUAL34_VALUE_ID
, QUAL34_VALUE1
, QUAL34_VALUE2
, QUAL34_VALUE3
, QUAL35_VALUE_ID
, QUAL35_VALUE1
, QUAL35_VALUE2
, QUAL35_VALUE3
, QUAL36_VALUE_ID
, QUAL36_VALUE1
, QUAL36_VALUE2
, QUAL36_VALUE3
, QUAL37_VALUE_ID
, QUAL37_VALUE1
, QUAL37_VALUE2
, QUAL37_VALUE3
, QUAL38_VALUE_ID
, QUAL38_VALUE1
, QUAL38_VALUE2
, QUAL38_VALUE3
, QUAL39_VALUE_ID
, QUAL39_VALUE1
, QUAL39_VALUE2
, QUAL39_VALUE3
, QUAL40_VALUE_ID
, QUAL40_VALUE1
, QUAL40_VALUE2
, QUAL40_VALUE3
, QUAL41_VALUE_ID
, QUAL41_VALUE1
, QUAL41_VALUE2
, QUAL41_VALUE3
, QUAL42_VALUE_ID
, QUAL42_VALUE1
, QUAL42_VALUE2
, QUAL42_VALUE3
, QUAL43_VALUE_ID
, QUAL43_VALUE1
, QUAL43_VALUE2
, QUAL43_VALUE3
, QUAL44_VALUE_ID
, QUAL44_VALUE1
, QUAL44_VALUE2
, QUAL44_VALUE3
, QUAL45_VALUE_ID
, QUAL45_VALUE1
, QUAL45_VALUE2
, QUAL45_VALUE3
, QUAL46_VALUE_ID
, QUAL46_VALUE1
, QUAL46_VALUE2
, QUAL46_VALUE3
, QUAL47_VALUE_ID
, QUAL47_VALUE1
, QUAL47_VALUE2
, QUAL47_VALUE3
, QUAL48_VALUE_ID
, QUAL48_VALUE1
, QUAL48_VALUE2
, QUAL48_VALUE3
, QUAL49_VALUE_ID
, QUAL49_VALUE1
, QUAL49_VALUE2
, QUAL49_VALUE3
, QUAL50_VALUE_ID
, QUAL50_VALUE1
, QUAL50_VALUE2
, QUAL50_VALUE3
, QUAL51_VALUE_ID
, QUAL51_VALUE1
, QUAL51_VALUE2
, QUAL51_VALUE3
, QUAL52_VALUE_ID
, QUAL52_VALUE1
, QUAL52_VALUE2
, QUAL52_VALUE3
, QUAL53_VALUE_ID
, QUAL53_VALUE1
, QUAL53_VALUE2
, QUAL53_VALUE3
, QUAL54_VALUE_ID
, QUAL54_VALUE1
, QUAL54_VALUE2
, QUAL54_VALUE3
, QUAL55_VALUE_ID
, QUAL55_VALUE1
, QUAL55_VALUE2
, QUAL55_VALUE3
, QUAL56_VALUE_ID
, QUAL56_VALUE1
, QUAL56_VALUE2
, QUAL56_VALUE3
, QUAL57_VALUE_ID
, QUAL57_VALUE1
, QUAL57_VALUE2
, QUAL57_VALUE3
, QUAL58_VALUE_ID
, QUAL58_VALUE1
, QUAL58_VALUE2
, QUAL58_VALUE3
, QUAL59_VALUE_ID
, QUAL59_VALUE1
, QUAL59_VALUE2
, QUAL59_VALUE3
, QUAL60_VALUE_ID
, QUAL60_VALUE1
, QUAL60_VALUE2
, QUAL60_VALUE3
, QUAL61_VALUE_ID
, QUAL61_VALUE1
, QUAL61_VALUE2
, QUAL61_VALUE3
, QUAL62_VALUE_ID
, QUAL62_VALUE1
, QUAL62_VALUE2
, QUAL62_VALUE3
, QUAL63_VALUE_ID
, QUAL63_VALUE1
, QUAL63_VALUE2
, QUAL63_VALUE3
, QUAL64_VALUE_ID
, QUAL64_VALUE1
, QUAL64_VALUE2
, QUAL64_VALUE3
, QUAL65_VALUE_ID
, QUAL65_VALUE1
, QUAL65_VALUE2
, QUAL65_VALUE3
, QUAL66_VALUE_ID
, QUAL66_VALUE1
, QUAL66_VALUE2
, QUAL66_VALUE3
, QUAL67_VALUE_ID
, QUAL67_VALUE1
, QUAL67_VALUE2
, QUAL67_VALUE3
, QUAL68_VALUE_ID
, QUAL68_VALUE1
, QUAL68_VALUE2
, QUAL68_VALUE3
, QUAL69_VALUE_ID
, QUAL69_VALUE1
, QUAL69_VALUE2
, QUAL69_VALUE3
, QUAL70_VALUE_ID
, QUAL70_VALUE1
, QUAL70_VALUE2
, QUAL70_VALUE3
, QUAL71_VALUE_ID
, QUAL71_VALUE1
, QUAL71_VALUE2
, QUAL71_VALUE3
, QUAL72_VALUE_ID
, QUAL72_VALUE1
, QUAL72_VALUE2
, QUAL72_VALUE3
, QUAL73_VALUE_ID
, QUAL73_VALUE1
, QUAL73_VALUE2
, QUAL73_VALUE3
, QUAL74_VALUE_ID
, QUAL74_VALUE1
, QUAL74_VALUE2
, QUAL74_VALUE3
, QUAL75_VALUE_ID
, QUAL75_VALUE1
, QUAL75_VALUE2
, QUAL75_VALUE3
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, RESOURCE_TYPE
, RESOURCE_NAME
, RESOURCE_ID
, RESOURCE_GROUP
, GROUP_ID
, RESOURCE_ROLE
, ROLE_CODE
, EMAIL
, RES_START_DATE
, RES_END_DATE
, TERR_RSC_ACCESS_ID1
, TRANS_ACCESS_CODE1
, TERR_RSC_ACCESS_ID2
, TRANS_ACCESS_CODE2
, TERR_RSC_ACCESS_ID3
, TRANS_ACCESS_CODE3
, TERR_RSC_ACCESS_ID4
, TRANS_ACCESS_CODE4
, TERR_RSC_ACCESS_ID5
, TRANS_ACCESS_CODE5
, TERR_RSC_ACCESS_ID6
, TRANS_ACCESS_CODE6
, TERR_RSC_ACCESS_ID7
, TRANS_ACCESS_CODE7
, TERR_RSC_ACCESS_ID8
, TRANS_ACCESS_CODE8
, TERR_RSC_ACCESS_ID9
, TRANS_ACCESS_CODE9
, TERR_RSC_ACCESS_ID10
, TRANS_ACCESS_CODE10
, RSC_ATTRIBUTE_CATEGORY
, RSC_ATTRIBUTE1
, RSC_ATTRIBUTE2
, RSC_ATTRIBUTE3
, RSC_ATTRIBUTE4
, RSC_ATTRIBUTE5
, RSC_ATTRIBUTE6
, RSC_ATTRIBUTE7
, RSC_ATTRIBUTE8
, RSC_ATTRIBUTE9
, RSC_ATTRIBUTE10
, RSC_ATTRIBUTE11
, RSC_ATTRIBUTE12
, RSC_ATTRIBUTE13
, RSC_ATTRIBUTE14
, RSC_ATTRIBUTE15
, TERR_RSC_ID
FROM APPS.JTY_WEBADI_OTH_TERR_V;
APPS
JTY_WEBADI_OTH_TERR_INTF
JTY_WEBADI_RESOURCES
APPS.JTY_WEBADI_OTH_TERR_V is not referenced by any database object
|
|
|
|