[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_V is not referenced by any database object
|
|
|