[Home] [Help]
View: CAC_TASK_RS_EXTNS_SEC
| Product: | JTF - CRM Foundation |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT "RESOURCE_ID"
, "CREATED_BY"
, "CREATION_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
, "CATEGORY"
, "RESOURCE_NUMBER"
, "SOURCE_ID"
, "ADDRESS_ID"
, "CONTACT_ID"
, "MANAGING_EMPLOYEE_ID"
, "START_DATE_ACTIVE"
, "END_DATE_ACTIVE"
, "TIME_ZONE"
, "COST_PER_HR"
, "PRIMARY_LANGUAGE"
, "SECONDARY_LANGUAGE"
, "IES_AGENT_LOGIN"
, "SERVER_GROUP_ID"
, "ASSIGNED_TO_GROUP_ID"
, "COST_CENTER"
, "CHARGE_TO_COST_CENTER"
, "COMPENSATION_CURRENCY_CODE"
, "COMMISSIONABLE_FLAG"
, "HOLD_REASON_CODE"
, "HOLD_PAYMENT"
, "COMP_SERVICE_TEAM_ID"
, "TRANSACTION_NUMBER"
, "OBJECT_VERSION_NUMBER"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "ATTRIBUTE_CATEGORY"
, "USER_ID"
, "SUPPORT_SITE_ID"
, "LOCATION"
, "SECURITY_GROUP_ID"
, "SUPPORT_SITE"
, "SOURCE_NAME"
, "SOURCE_NUMBER"
, "SOURCE_JOB_TITLE"
, "SOURCE_EMAIL"
, "SOURCE_PHONE"
, "SOURCE_ORG_ID"
, "SOURCE_ORG_NAME"
, "SOURCE_ADDRESS1"
, "SOURCE_ADDRESS2"
, "SOURCE_ADDRESS3"
, "SOURCE_ADDRESS4"
, "SOURCE_CITY"
, "SOURCE_POSTAL_CODE"
, "SOURCE_STATE"
, "SOURCE_PROVINCE"
, "SOURCE_COUNTY"
, "SOURCE_COUNTRY"
, "SOURCE_MGR_ID"
, "SOURCE_MGR_NAME"
, "SOURCE_BUSINESS_GRP_ID"
, "SOURCE_BUSINESS_GRP_NAME"
, "SOURCE_FIRST_NAME"
, "SOURCE_MIDDLE_NAME"
, "SOURCE_LAST_NAME"
, "SOURCE_CATEGORY"
, "SOURCE_STATUS"
, "USER_NAME"
, "SOURCE_OFFICE"
, "SOURCE_LOCATION"
, "SOURCE_MAILSTOP"
, "SOURCE_MOBILE_PHONE"
, "SOURCE_PAGER"
FROM JTF_RS_RESOURCE_EXTNS