VIEW: APPS.JTF_RS_DEFRESOURCES_V

Source

View Text - Preformatted

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
   

View Text - HTML Formatted

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