[Home] [Help]
View: JTF_RS_DEFRESOURCES_V
View Text
SELECT RSC.ROWID 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
APPS.JTF_RS_DEFRESOURCES_V