[Home] [Help] [Dependency Information]
Object Name: | JTF_TTY_WEBADI_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_SEQUENCE | NUMBER | Yes | ||
USER_ID | NUMBER | Yes | ||
TERR_GRP_ACCT_ID | NUMBER | |||
JTF_TTY_WEBADI_INT_ID | NUMBER | |||
ALIGNMENT_ID | NUMBER | |||
NAMED_ACCOUNT | VARCHAR2 | (360) | ||
SITE_TYPE | VARCHAR2 | (80) | ||
DUNS | VARCHAR2 | (30) | ||
TRADE_NAME | VARCHAR2 | (240) | ||
GU_DUNS | VARCHAR2 | (360) | ||
GU_NAME | VARCHAR2 | (360) | ||
DU_DUNS | VARCHAR2 | (360) | ||
DU_NAME | VARCHAR2 | (360) | ||
CITY | VARCHAR2 | (60) | ||
STATE | VARCHAR2 | (60) | ||
PROVINCE | VARCHAR2 | (60) | ||
POSTAL_CODE | VARCHAR2 | (60) | ||
DNB_ANNUAL_REV | NUMBER | |||
DNB_NUM_OF_EM | NUMBER | |||
PRIOR_WON | NUMBER | |||
TERRITORY_GROUP | VARCHAR2 | (150) | ||
RESOURCE1_NAME | VARCHAR2 | (360) | ||
RESOURCE1_ID | NUMBER | |||
GROUP1_NAME | VARCHAR2 | (60) | ||
GROUP1_ID | NUMBER | |||
ROLE1_NAME | VARCHAR2 | (60) | ||
ROLE1_ID | NUMBER | |||
RESOURCE2_NAME | VARCHAR2 | (360) | ||
RESOURCE2_ID | NUMBER | |||
GROUP2_NAME | VARCHAR2 | (60) | ||
GROUP2_ID | NUMBER | |||
ROLE2_NAME | VARCHAR2 | (60) | ||
ROLE2_ID | NUMBER | |||
RESOURCE3_NAME | VARCHAR2 | (360) | ||
RESOURCE3_ID | NUMBER | |||
GROUP3_NAME | VARCHAR2 | (60) | ||
GROUP3_ID | NUMBER | |||
ROLE3_NAME | VARCHAR2 | (60) | ||
ROLE3_ID | NUMBER | |||
RESOURCE4_NAME | VARCHAR2 | (360) | ||
RESOURCE4_ID | NUMBER | |||
GROUP4_NAME | VARCHAR2 | (60) | ||
GROUP4_ID | NUMBER | |||
ROLE4_NAME | VARCHAR2 | (60) | ||
ROLE4_ID | NUMBER | |||
RESOURCE5_NAME | VARCHAR2 | (360) | ||
RESOURCE5_ID | NUMBER | |||
GROUP5_NAME | VARCHAR2 | (60) | ||
GROUP5_ID | NUMBER | |||
ROLE5_NAME | VARCHAR2 | (60) | ||
ROLE5_ID | NUMBER | |||
RESOURCE6_NAME | VARCHAR2 | (360) | ||
RESOURCE6_ID | NUMBER | |||
GROUP6_NAME | VARCHAR2 | (60) | ||
GROUP6_ID | NUMBER | |||
ROLE6_NAME | VARCHAR2 | (60) | ||
ROLE6_ID | NUMBER | |||
RESOURCE7_NAME | VARCHAR2 | (360) | ||
RESOURCE7_ID | NUMBER | |||
GROUP7_NAME | VARCHAR2 | (60) | ||
GROUP7_ID | NUMBER | |||
ROLE7_NAME | VARCHAR2 | (60) | ||
ROLE7_ID | NUMBER | |||
RESOURCE8_NAME | VARCHAR2 | (360) | ||
RESOURCE8_ID | NUMBER | |||
GROUP8_NAME | VARCHAR2 | (60) | ||
GROUP8_ID | NUMBER | |||
ROLE8_NAME | VARCHAR2 | (60) | ||
ROLE8_ID | NUMBER | |||
RESOURCE9_NAME | VARCHAR2 | (360) | ||
RESOURCE9_ID | NUMBER | |||
GROUP9_NAME | VARCHAR2 | (60) | ||
GROUP9_ID | NUMBER | |||
ROLE9_NAME | VARCHAR2 | (60) | ||
ROLE9_ID | NUMBER | |||
RESOURCE10_NAME | VARCHAR2 | (360) | ||
RESOURCE10_ID | NUMBER | |||
GROUP10_NAME | VARCHAR2 | (60) | ||
GROUP10_ID | NUMBER | |||
ROLE10_NAME | VARCHAR2 | (60) | ||
ROLE10_ID | NUMBER | |||
RESOURCE11_NAME | VARCHAR2 | (360) | ||
RESOURCE11_ID | NUMBER | |||
GROUP11_NAME | VARCHAR2 | (60) | ||
GROUP11_ID | NUMBER | |||
ROLE11_NAME | VARCHAR2 | (60) | ||
ROLE11_ID | NUMBER | |||
RESOURCE12_NAME | VARCHAR2 | (360) | ||
RESOURCE12_ID | NUMBER | |||
GROUP12_NAME | VARCHAR2 | (60) | ||
GROUP12_ID | NUMBER | |||
ROLE12_NAME | VARCHAR2 | (60) | ||
ROLE12_ID | NUMBER | |||
RESOURCE13_NAME | VARCHAR2 | (360) | ||
RESOURCE13_ID | NUMBER | |||
GROUP13_NAME | VARCHAR2 | (60) | ||
GROUP13_ID | NUMBER | |||
ROLE13_NAME | VARCHAR2 | (60) | ||
ROLE13_ID | NUMBER | |||
RESOURCE14_NAME | VARCHAR2 | (360) | ||
RESOURCE14_ID | NUMBER | |||
GROUP14_NAME | VARCHAR2 | (60) | ||
GROUP14_ID | NUMBER | |||
ROLE14_NAME | VARCHAR2 | (60) | ||
ROLE14_ID | NUMBER | |||
RESOURCE15_NAME | VARCHAR2 | (360) | ||
RESOURCE15_ID | NUMBER | |||
GROUP15_NAME | VARCHAR2 | (60) | ||
GROUP15_ID | NUMBER | |||
ROLE15_NAME | VARCHAR2 | (60) | ||
ROLE15_ID | NUMBER | |||
RESOURCE16_NAME | VARCHAR2 | (360) | ||
RESOURCE16_ID | NUMBER | |||
GROUP16_NAME | VARCHAR2 | (60) | ||
GROUP16_ID | NUMBER | |||
ROLE16_NAME | VARCHAR2 | (60) | ||
ROLE16_ID | NUMBER | |||
RESOURCE17_NAME | VARCHAR2 | (360) | ||
RESOURCE17_ID | NUMBER | |||
GROUP17_NAME | VARCHAR2 | (60) | ||
GROUP17_ID | NUMBER | |||
ROLE17_NAME | VARCHAR2 | (60) | ||
ROLE17_ID | NUMBER | |||
RESOURCE18_NAME | VARCHAR2 | (360) | ||
RESOURCE18_ID | NUMBER | |||
GROUP18_NAME | VARCHAR2 | (60) | ||
GROUP18_ID | NUMBER | |||
ROLE18_NAME | VARCHAR2 | (60) | ||
ROLE18_ID | NUMBER | |||
RESOURCE19_NAME | VARCHAR2 | (360) | ||
RESOURCE19_ID | NUMBER | |||
GROUP19_NAME | VARCHAR2 | (60) | ||
GROUP19_ID | NUMBER | |||
ROLE19_NAME | VARCHAR2 | (60) | ||
ROLE19_ID | NUMBER | |||
RESOURCE20_NAME | VARCHAR2 | (360) | ||
RESOURCE20_ID | NUMBER | |||
GROUP20_NAME | VARCHAR2 | (60) | ||
GROUP20_ID | NUMBER | |||
ROLE20_NAME | VARCHAR2 | (60) | ||
ROLE20_ID | NUMBER | |||
RESOURCE21_NAME | VARCHAR2 | (360) | ||
RESOURCE21_ID | NUMBER | |||
GROUP21_NAME | VARCHAR2 | (60) | ||
GROUP21_ID | NUMBER | |||
ROLE21_NAME | VARCHAR2 | (60) | ||
ROLE21_ID | NUMBER | |||
RESOURCE22_NAME | VARCHAR2 | (360) | ||
RESOURCE22_ID | NUMBER | |||
GROUP22_NAME | VARCHAR2 | (60) | ||
GROUP22_ID | NUMBER | |||
ROLE22_NAME | VARCHAR2 | (60) | ||
ROLE22_ID | NUMBER | |||
RESOURCE23_NAME | VARCHAR2 | (360) | ||
RESOURCE23_ID | NUMBER | |||
GROUP23_NAME | VARCHAR2 | (60) | ||
GROUP23_ID | NUMBER | |||
ROLE23_NAME | VARCHAR2 | (60) | ||
ROLE23_ID | NUMBER | |||
RESOURCE24_NAME | VARCHAR2 | (360) | ||
RESOURCE24_ID | NUMBER | |||
GROUP24_NAME | VARCHAR2 | (60) | ||
GROUP24_ID | NUMBER | |||
ROLE24_NAME | VARCHAR2 | (60) | ||
ROLE24_ID | NUMBER | |||
RESOURCE25_NAME | VARCHAR2 | (360) | ||
RESOURCE25_ID | NUMBER | |||
GROUP25_NAME | VARCHAR2 | (60) | ||
GROUP25_ID | NUMBER | |||
ROLE25_NAME | VARCHAR2 | (60) | ||
ROLE25_ID | NUMBER | |||
RESOURCE26_NAME | VARCHAR2 | (360) | ||
RESOURCE26_ID | NUMBER | |||
GROUP26_NAME | VARCHAR2 | (60) | ||
GROUP26_ID | NUMBER | |||
ROLE26_NAME | VARCHAR2 | (60) | ||
ROLE26_ID | NUMBER | |||
RESOURCE27_NAME | VARCHAR2 | (360) | ||
RESOURCE27_ID | NUMBER | |||
GROUP27_NAME | VARCHAR2 | (60) | ||
GROUP27_ID | NUMBER | |||
ROLE27_NAME | VARCHAR2 | (60) | ||
ROLE27_ID | NUMBER | |||
RESOURCE28_NAME | VARCHAR2 | (360) | ||
RESOURCE28_ID | NUMBER | |||
GROUP28_NAME | VARCHAR2 | (60) | ||
GROUP28_ID | NUMBER | |||
ROLE28_NAME | VARCHAR2 | (60) | ||
ROLE28_ID | NUMBER | |||
RESOURCE29_NAME | VARCHAR2 | (360) | ||
RESOURCE29_ID | NUMBER | |||
GROUP29_NAME | VARCHAR2 | (60) | ||
GROUP29_ID | NUMBER | |||
ROLE29_NAME | VARCHAR2 | (60) | ||
ROLE29_ID | NUMBER | |||
RESOURCE30_NAME | VARCHAR2 | (360) | ||
RESOURCE30_ID | NUMBER | |||
GROUP30_NAME | VARCHAR2 | (60) | ||
GROUP30_ID | NUMBER | |||
ROLE30_NAME | VARCHAR2 | (60) | ||
ROLE30_ID | NUMBER | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PARTY_NUMBER | VARCHAR2 | (30) | ||
TO_TERRITORY_GROUP | VARCHAR2 | (150) | ||
DELETE_FLAG | VARCHAR2 | (30) | ||
PARTY_SITE_NUMBER | VARCHAR2 | (30) | ||
SALES_MANAGER | VARCHAR2 | (1) | ||
PHONETIC_NAME | VARCHAR2 | (360) | ||
IDENTIFYING_ADDRESS | VARCHAR2 | (1) | ||
SALES_GROUP | VARCHAR2 | (360) | ||
SALES_ROLE | VARCHAR2 | (360) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
RESOURCE1_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE1_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE1_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE1_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE1_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE1_START_DATE | DATE | |||
RESOURCE1_END_DATE | DATE | |||
RESOURCE2_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE2_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE2_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE2_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE2_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE2_START_DATE | DATE | |||
RESOURCE2_END_DATE | DATE | |||
RESOURCE3_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE3_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE3_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE3_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE3_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE3_START_DATE | DATE | |||
RESOURCE3_END_DATE | DATE | |||
RESOURCE4_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE4_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE4_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE4_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE4_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE4_START_DATE | DATE | |||
RESOURCE4_END_DATE | DATE | |||
RESOURCE5_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE5_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE5_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE5_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE5_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE5_START_DATE | DATE | |||
RESOURCE5_END_DATE | DATE | |||
RESOURCE6_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE6_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE6_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE6_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE6_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE6_START_DATE | DATE | |||
RESOURCE6_END_DATE | DATE | |||
RESOURCE7_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE7_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE7_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE7_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE7_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE7_START_DATE | DATE | |||
RESOURCE7_END_DATE | DATE | |||
RESOURCE8_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE8_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE8_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE8_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE8_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE8_START_DATE | DATE | |||
RESOURCE8_END_DATE | DATE | |||
RESOURCE9_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE9_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE9_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE9_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE9_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE9_START_DATE | DATE | |||
RESOURCE9_END_DATE | DATE | |||
RESOURCE10_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE10_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE10_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE10_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE10_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE10_START_DATE | DATE | |||
RESOURCE10_END_DATE | DATE | |||
RESOURCE11_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE11_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE11_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE11_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE11_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE12_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE12_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE12_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE12_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE12_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE13_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE13_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE13_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE13_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE13_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE14_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE14_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE14_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE14_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE14_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE15_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE15_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE15_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE15_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE15_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE16_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE16_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE16_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE16_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE16_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE17_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE17_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE17_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE17_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE17_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE18_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE18_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE18_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE18_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE18_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE19_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE19_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE19_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE19_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE19_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE20_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE20_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE20_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE20_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE20_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE21_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE21_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE21_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE21_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE21_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE22_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE22_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE22_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE22_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE22_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE23_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE23_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE23_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE23_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE23_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE24_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE24_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE24_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE24_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE24_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE25_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE25_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE25_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE25_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE25_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE26_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE26_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE26_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE26_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE26_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE27_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE27_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE27_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE27_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE27_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE28_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE28_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE28_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE28_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE28_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE29_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE29_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE29_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE29_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE29_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE30_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RESOURCE30_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RESOURCE30_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RESOURCE30_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RESOURCE30_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RESOURCE11_START_DATE | DATE | |||
RESOURCE12_START_DATE | DATE | |||
RESOURCE13_START_DATE | DATE | |||
RESOURCE14_START_DATE | DATE | |||
RESOURCE15_START_DATE | DATE | |||
RESOURCE16_START_DATE | DATE | |||
RESOURCE17_START_DATE | DATE | |||
RESOURCE18_START_DATE | DATE | |||
RESOURCE19_START_DATE | DATE | |||
RESOURCE20_START_DATE | DATE | |||
RESOURCE21_START_DATE | DATE | |||
RESOURCE22_START_DATE | DATE | |||
RESOURCE23_START_DATE | DATE | |||
RESOURCE24_START_DATE | DATE | |||
RESOURCE25_START_DATE | DATE | |||
RESOURCE26_START_DATE | DATE | |||
RESOURCE27_START_DATE | DATE | |||
RESOURCE28_START_DATE | DATE | |||
RESOURCE29_START_DATE | DATE | |||
RESOURCE30_START_DATE | DATE | |||
RESOURCE11_END_DATE | DATE | |||
RESOURCE12_END_DATE | DATE | |||
RESOURCE13_END_DATE | DATE | |||
RESOURCE14_END_DATE | DATE | |||
RESOURCE15_END_DATE | DATE | |||
RESOURCE16_END_DATE | DATE | |||
RESOURCE17_END_DATE | DATE | |||
RESOURCE18_END_DATE | DATE | |||
RESOURCE19_END_DATE | DATE | |||
RESOURCE20_END_DATE | DATE | |||
RESOURCE21_END_DATE | DATE | |||
RESOURCE22_END_DATE | DATE | |||
RESOURCE23_END_DATE | DATE | |||
RESOURCE24_END_DATE | DATE | |||
RESOURCE25_END_DATE | DATE | |||
RESOURCE26_END_DATE | DATE | |||
RESOURCE27_END_DATE | DATE | |||
RESOURCE28_END_DATE | DATE | |||
RESOURCE29_END_DATE | DATE | |||
RESOURCE30_END_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT USER_SEQUENCE
, USER_ID
, TERR_GRP_ACCT_ID
, JTF_TTY_WEBADI_INT_ID
, ALIGNMENT_ID
, NAMED_ACCOUNT
, SITE_TYPE
, DUNS
, TRADE_NAME
, GU_DUNS
, GU_NAME
, DU_DUNS
, DU_NAME
, CITY
, STATE
, PROVINCE
, POSTAL_CODE
, DNB_ANNUAL_REV
, DNB_NUM_OF_EM
, PRIOR_WON
, TERRITORY_GROUP
, RESOURCE1_NAME
, RESOURCE1_ID
, GROUP1_NAME
, GROUP1_ID
, ROLE1_NAME
, ROLE1_ID
, RESOURCE2_NAME
, RESOURCE2_ID
, GROUP2_NAME
, GROUP2_ID
, ROLE2_NAME
, ROLE2_ID
, RESOURCE3_NAME
, RESOURCE3_ID
, GROUP3_NAME
, GROUP3_ID
, ROLE3_NAME
, ROLE3_ID
, RESOURCE4_NAME
, RESOURCE4_ID
, GROUP4_NAME
, GROUP4_ID
, ROLE4_NAME
, ROLE4_ID
, RESOURCE5_NAME
, RESOURCE5_ID
, GROUP5_NAME
, GROUP5_ID
, ROLE5_NAME
, ROLE5_ID
, RESOURCE6_NAME
, RESOURCE6_ID
, GROUP6_NAME
, GROUP6_ID
, ROLE6_NAME
, ROLE6_ID
, RESOURCE7_NAME
, RESOURCE7_ID
, GROUP7_NAME
, GROUP7_ID
, ROLE7_NAME
, ROLE7_ID
, RESOURCE8_NAME
, RESOURCE8_ID
, GROUP8_NAME
, GROUP8_ID
, ROLE8_NAME
, ROLE8_ID
, RESOURCE9_NAME
, RESOURCE9_ID
, GROUP9_NAME
, GROUP9_ID
, ROLE9_NAME
, ROLE9_ID
, RESOURCE10_NAME
, RESOURCE10_ID
, GROUP10_NAME
, GROUP10_ID
, ROLE10_NAME
, ROLE10_ID
, RESOURCE11_NAME
, RESOURCE11_ID
, GROUP11_NAME
, GROUP11_ID
, ROLE11_NAME
, ROLE11_ID
, RESOURCE12_NAME
, RESOURCE12_ID
, GROUP12_NAME
, GROUP12_ID
, ROLE12_NAME
, ROLE12_ID
, RESOURCE13_NAME
, RESOURCE13_ID
, GROUP13_NAME
, GROUP13_ID
, ROLE13_NAME
, ROLE13_ID
, RESOURCE14_NAME
, RESOURCE14_ID
, GROUP14_NAME
, GROUP14_ID
, ROLE14_NAME
, ROLE14_ID
, RESOURCE15_NAME
, RESOURCE15_ID
, GROUP15_NAME
, GROUP15_ID
, ROLE15_NAME
, ROLE15_ID
, RESOURCE16_NAME
, RESOURCE16_ID
, GROUP16_NAME
, GROUP16_ID
, ROLE16_NAME
, ROLE16_ID
, RESOURCE17_NAME
, RESOURCE17_ID
, GROUP17_NAME
, GROUP17_ID
, ROLE17_NAME
, ROLE17_ID
, RESOURCE18_NAME
, RESOURCE18_ID
, GROUP18_NAME
, GROUP18_ID
, ROLE18_NAME
, ROLE18_ID
, RESOURCE19_NAME
, RESOURCE19_ID
, GROUP19_NAME
, GROUP19_ID
, ROLE19_NAME
, ROLE19_ID
, RESOURCE20_NAME
, RESOURCE20_ID
, GROUP20_NAME
, GROUP20_ID
, ROLE20_NAME
, ROLE20_ID
, RESOURCE21_NAME
, RESOURCE21_ID
, GROUP21_NAME
, GROUP21_ID
, ROLE21_NAME
, ROLE21_ID
, RESOURCE22_NAME
, RESOURCE22_ID
, GROUP22_NAME
, GROUP22_ID
, ROLE22_NAME
, ROLE22_ID
, RESOURCE23_NAME
, RESOURCE23_ID
, GROUP23_NAME
, GROUP23_ID
, ROLE23_NAME
, ROLE23_ID
, RESOURCE24_NAME
, RESOURCE24_ID
, GROUP24_NAME
, GROUP24_ID
, ROLE24_NAME
, ROLE24_ID
, RESOURCE25_NAME
, RESOURCE25_ID
, GROUP25_NAME
, GROUP25_ID
, ROLE25_NAME
, ROLE25_ID
, RESOURCE26_NAME
, RESOURCE26_ID
, GROUP26_NAME
, GROUP26_ID
, ROLE26_NAME
, ROLE26_ID
, RESOURCE27_NAME
, RESOURCE27_ID
, GROUP27_NAME
, GROUP27_ID
, ROLE27_NAME
, ROLE27_ID
, RESOURCE28_NAME
, RESOURCE28_ID
, GROUP28_NAME
, GROUP28_ID
, ROLE28_NAME
, ROLE28_ID
, RESOURCE29_NAME
, RESOURCE29_ID
, GROUP29_NAME
, GROUP29_ID
, ROLE29_NAME
, ROLE29_ID
, RESOURCE30_NAME
, RESOURCE30_ID
, GROUP30_NAME
, GROUP30_ID
, ROLE30_NAME
, ROLE30_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PARTY_NUMBER
, TO_TERRITORY_GROUP
, DELETE_FLAG
, PARTY_SITE_NUMBER
, SALES_MANAGER
, PHONETIC_NAME
, IDENTIFYING_ADDRESS
, SALES_GROUP
, SALES_ROLE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, START_DATE
, END_DATE
, RESOURCE1_ATTRIBUTE1
, RESOURCE1_ATTRIBUTE2
, RESOURCE1_ATTRIBUTE3
, RESOURCE1_ATTRIBUTE4
, RESOURCE1_ATTRIBUTE5
, RESOURCE1_START_DATE
, RESOURCE1_END_DATE
, RESOURCE2_ATTRIBUTE1
, RESOURCE2_ATTRIBUTE2
, RESOURCE2_ATTRIBUTE3
, RESOURCE2_ATTRIBUTE4
, RESOURCE2_ATTRIBUTE5
, RESOURCE2_START_DATE
, RESOURCE2_END_DATE
, RESOURCE3_ATTRIBUTE1
, RESOURCE3_ATTRIBUTE2
, RESOURCE3_ATTRIBUTE3
, RESOURCE3_ATTRIBUTE4
, RESOURCE3_ATTRIBUTE5
, RESOURCE3_START_DATE
, RESOURCE3_END_DATE
, RESOURCE4_ATTRIBUTE1
, RESOURCE4_ATTRIBUTE2
, RESOURCE4_ATTRIBUTE3
, RESOURCE4_ATTRIBUTE4
, RESOURCE4_ATTRIBUTE5
, RESOURCE4_START_DATE
, RESOURCE4_END_DATE
, RESOURCE5_ATTRIBUTE1
, RESOURCE5_ATTRIBUTE2
, RESOURCE5_ATTRIBUTE3
, RESOURCE5_ATTRIBUTE4
, RESOURCE5_ATTRIBUTE5
, RESOURCE5_START_DATE
, RESOURCE5_END_DATE
, RESOURCE6_ATTRIBUTE1
, RESOURCE6_ATTRIBUTE2
, RESOURCE6_ATTRIBUTE3
, RESOURCE6_ATTRIBUTE4
, RESOURCE6_ATTRIBUTE5
, RESOURCE6_START_DATE
, RESOURCE6_END_DATE
, RESOURCE7_ATTRIBUTE1
, RESOURCE7_ATTRIBUTE2
, RESOURCE7_ATTRIBUTE3
, RESOURCE7_ATTRIBUTE4
, RESOURCE7_ATTRIBUTE5
, RESOURCE7_START_DATE
, RESOURCE7_END_DATE
, RESOURCE8_ATTRIBUTE1
, RESOURCE8_ATTRIBUTE2
, RESOURCE8_ATTRIBUTE3
, RESOURCE8_ATTRIBUTE4
, RESOURCE8_ATTRIBUTE5
, RESOURCE8_START_DATE
, RESOURCE8_END_DATE
, RESOURCE9_ATTRIBUTE1
, RESOURCE9_ATTRIBUTE2
, RESOURCE9_ATTRIBUTE3
, RESOURCE9_ATTRIBUTE4
, RESOURCE9_ATTRIBUTE5
, RESOURCE9_START_DATE
, RESOURCE9_END_DATE
, RESOURCE10_ATTRIBUTE1
, RESOURCE10_ATTRIBUTE2
, RESOURCE10_ATTRIBUTE3
, RESOURCE10_ATTRIBUTE4
, RESOURCE10_ATTRIBUTE5
, RESOURCE10_START_DATE
, RESOURCE10_END_DATE
, RESOURCE11_ATTRIBUTE1
, RESOURCE11_ATTRIBUTE2
, RESOURCE11_ATTRIBUTE3
, RESOURCE11_ATTRIBUTE4
, RESOURCE11_ATTRIBUTE5
, RESOURCE12_ATTRIBUTE1
, RESOURCE12_ATTRIBUTE2
, RESOURCE12_ATTRIBUTE3
, RESOURCE12_ATTRIBUTE4
, RESOURCE12_ATTRIBUTE5
, RESOURCE13_ATTRIBUTE1
, RESOURCE13_ATTRIBUTE2
, RESOURCE13_ATTRIBUTE3
, RESOURCE13_ATTRIBUTE4
, RESOURCE13_ATTRIBUTE5
, RESOURCE14_ATTRIBUTE1
, RESOURCE14_ATTRIBUTE2
, RESOURCE14_ATTRIBUTE3
, RESOURCE14_ATTRIBUTE4
, RESOURCE14_ATTRIBUTE5
, RESOURCE15_ATTRIBUTE1
, RESOURCE15_ATTRIBUTE2
, RESOURCE15_ATTRIBUTE3
, RESOURCE15_ATTRIBUTE4
, RESOURCE15_ATTRIBUTE5
, RESOURCE16_ATTRIBUTE1
, RESOURCE16_ATTRIBUTE2
, RESOURCE16_ATTRIBUTE3
, RESOURCE16_ATTRIBUTE4
, RESOURCE16_ATTRIBUTE5
, RESOURCE17_ATTRIBUTE1
, RESOURCE17_ATTRIBUTE2
, RESOURCE17_ATTRIBUTE3
, RESOURCE17_ATTRIBUTE4
, RESOURCE17_ATTRIBUTE5
, RESOURCE18_ATTRIBUTE1
, RESOURCE18_ATTRIBUTE2
, RESOURCE18_ATTRIBUTE3
, RESOURCE18_ATTRIBUTE4
, RESOURCE18_ATTRIBUTE5
, RESOURCE19_ATTRIBUTE1
, RESOURCE19_ATTRIBUTE2
, RESOURCE19_ATTRIBUTE3
, RESOURCE19_ATTRIBUTE4
, RESOURCE19_ATTRIBUTE5
, RESOURCE20_ATTRIBUTE1
, RESOURCE20_ATTRIBUTE2
, RESOURCE20_ATTRIBUTE3
, RESOURCE20_ATTRIBUTE4
, RESOURCE20_ATTRIBUTE5
, RESOURCE21_ATTRIBUTE1
, RESOURCE21_ATTRIBUTE2
, RESOURCE21_ATTRIBUTE3
, RESOURCE21_ATTRIBUTE4
, RESOURCE21_ATTRIBUTE5
, RESOURCE22_ATTRIBUTE1
, RESOURCE22_ATTRIBUTE2
, RESOURCE22_ATTRIBUTE3
, RESOURCE22_ATTRIBUTE4
, RESOURCE22_ATTRIBUTE5
, RESOURCE23_ATTRIBUTE1
, RESOURCE23_ATTRIBUTE2
, RESOURCE23_ATTRIBUTE3
, RESOURCE23_ATTRIBUTE4
, RESOURCE23_ATTRIBUTE5
, RESOURCE24_ATTRIBUTE1
, RESOURCE24_ATTRIBUTE2
, RESOURCE24_ATTRIBUTE3
, RESOURCE24_ATTRIBUTE4
, RESOURCE24_ATTRIBUTE5
, RESOURCE25_ATTRIBUTE1
, RESOURCE25_ATTRIBUTE2
, RESOURCE25_ATTRIBUTE3
, RESOURCE25_ATTRIBUTE4
, RESOURCE25_ATTRIBUTE5
, RESOURCE26_ATTRIBUTE1
, RESOURCE26_ATTRIBUTE2
, RESOURCE26_ATTRIBUTE3
, RESOURCE26_ATTRIBUTE4
, RESOURCE26_ATTRIBUTE5
, RESOURCE27_ATTRIBUTE1
, RESOURCE27_ATTRIBUTE2
, RESOURCE27_ATTRIBUTE3
, RESOURCE27_ATTRIBUTE4
, RESOURCE27_ATTRIBUTE5
, RESOURCE28_ATTRIBUTE1
, RESOURCE28_ATTRIBUTE2
, RESOURCE28_ATTRIBUTE3
, RESOURCE28_ATTRIBUTE4
, RESOURCE28_ATTRIBUTE5
, RESOURCE29_ATTRIBUTE1
, RESOURCE29_ATTRIBUTE2
, RESOURCE29_ATTRIBUTE3
, RESOURCE29_ATTRIBUTE4
, RESOURCE29_ATTRIBUTE5
, RESOURCE30_ATTRIBUTE1
, RESOURCE30_ATTRIBUTE2
, RESOURCE30_ATTRIBUTE3
, RESOURCE30_ATTRIBUTE4
, RESOURCE30_ATTRIBUTE5
, RESOURCE11_START_DATE
, RESOURCE12_START_DATE
, RESOURCE13_START_DATE
, RESOURCE14_START_DATE
, RESOURCE15_START_DATE
, RESOURCE16_START_DATE
, RESOURCE17_START_DATE
, RESOURCE18_START_DATE
, RESOURCE19_START_DATE
, RESOURCE20_START_DATE
, RESOURCE21_START_DATE
, RESOURCE22_START_DATE
, RESOURCE23_START_DATE
, RESOURCE24_START_DATE
, RESOURCE25_START_DATE
, RESOURCE26_START_DATE
, RESOURCE27_START_DATE
, RESOURCE28_START_DATE
, RESOURCE29_START_DATE
, RESOURCE30_START_DATE
, RESOURCE11_END_DATE
, RESOURCE12_END_DATE
, RESOURCE13_END_DATE
, RESOURCE14_END_DATE
, RESOURCE15_END_DATE
, RESOURCE16_END_DATE
, RESOURCE17_END_DATE
, RESOURCE18_END_DATE
, RESOURCE19_END_DATE
, RESOURCE20_END_DATE
, RESOURCE21_END_DATE
, RESOURCE22_END_DATE
, RESOURCE23_END_DATE
, RESOURCE24_END_DATE
, RESOURCE25_END_DATE
, RESOURCE26_END_DATE
, RESOURCE27_END_DATE
, RESOURCE28_END_DATE
, RESOURCE29_END_DATE
, RESOURCE30_END_DATE
FROM JTF.JTF_TTY_WEBADI_INTERFACE#;
|
|
|