VIEW: APPS.JTF_RS_DEFRESOURCES_V

Source

View Text - Preformatted

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

   

View Text - HTML Formatted

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