[Home] [Help]
[Dependency Information]
[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#;
JTF
JTF_TTY_WEBADI_INTERFACE
APPS
JTF_TTY_WEBADI_INTERFACE
|
|
|
|