[Home] [Help]
View: JTF_RS_DEFRESOURCES_V
View Text
SELECT RSC.ROW_ID ROW_ID
,
RSC.RESOURCE_ID
,
RSC.CREATED_BY
,
RSC.CREATION_DATE
,
RSC.LAST_UPDATED_BY
,
RSC.LAST_UPDATE_DATE
,
RSC.LAST_UPDATE_LOGIN
,
RSC.CATEGORY
,
OBJ.NAME CATG_MEANING
,
RSC.RESOURCE_NUMBER
,
RSC.SOURCE_ID
,
RSC.ADDRESS_ID
,
RSC.CONTACT_ID
,
RSC.MANAGING_EMPLOYEE_ID
,
RSC.START_DATE_ACTIVE
,
RSC.END_DATE_ACTIVE
,
RSC.TIME_ZONE
,
RSC.COST_PER_HR
,
RSC.PRIMARY_LANGUAGE
,
RSC.SECONDARY_LANGUAGE
,
RSC.SUPPORT_SITE_ID
,
RSC.IES_AGENT_LOGIN
,
RSC.SERVER_GROUP_ID
,
RSC.ASSIGNED_TO_GROUP_ID
,
RSC.COST_CENTER
,
RSC.CHARGE_TO_COST_CENTER
,
RSC.COMPENSATION_CURRENCY_CODE
,
RSC.COMMISSIONABLE_FLAG
,
RSC.HOLD_REASON_CODE
,
RSC.HOLD_PAYMENT
,
RSC.COMP_SERVICE_TEAM_ID
,
RSC.TRANSACTION_NUMBER
,
RSC.OBJECT_VERSION_NUMBER
,
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
,
RSC.ATTRIBUTE_CATEGORY
,
RSC.USER_ID
,
RSC.RESOURCE_NAME
,
RSC.SOURCE_NAME
,
RSC.SOURCE_NUMBER
,
RSC.SOURCE_JOB_TITLE
,
RSC.SOURCE_EMAIL
,
RSC.SOURCE_PHONE
,
RSC.SOURCE_ORG_ID
,
RSC.SOURCE_ORG_NAME
,
RSC.SOURCE_ADDRESS1
,
RSC.SOURCE_ADDRESS2
,
RSC.SOURCE_ADDRESS3
,
RSC.SOURCE_ADDRESS4
,
RSC.SOURCE_CITY
,
RSC.SOURCE_POSTAL_CODE
,
RSC.SOURCE_STATE
,
RSC.SOURCE_PROVINCE
,
RSC.SOURCE_COUNTY
,
RSC.SOURCE_COUNTRY
,
RSC.SOURCE_MGR_ID
,
RSC.SOURCE_MGR_NAME
,
RSC.SOURCE_BUSINESS_GRP_ID
,
RSC.SOURCE_BUSINESS_GRP_NAME
,
RSC.SOURCE_FIRST_NAME
,
RSC.SOURCE_MIDDLE_NAME
,
RSC.SOURCE_LAST_NAME
,
RSC.SOURCE_CATEGORY
,
RSC.SOURCE_STATUS
,
RSC.USER_NAME
,
RSC.SOURCE_OFFICE
,
RSC.SOURCE_LOCATION
,
RSC.SOURCE_MAILSTOP
,
RSC.SOURCE_MOBILE_PHONE
,
RSC.SOURCE_PAGER
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
,
JTF_OBJECTS_VL OBJ
WHERE RSC.CATEGORY = OBJ.OBJECT_CODE