VIEW: APPS.JTF_RS_DEFRESOURCES_VL

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, srp.SALESREP_NUMBER, srp.org_id SALESREP_ORG_ID,nvl(srp.status,'A') salesrep_status, 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, JTF_RS_SALESREPS_MO_V srp WHERE rsc.category = obj.object_code AND rsc.resource_id = srp.resource_id(+)

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
, SRP.SALESREP_NUMBER
, SRP.ORG_ID SALESREP_ORG_ID
, NVL(SRP.STATUS
, 'A') SALESREP_STATUS
, 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
, JTF_RS_SALESREPS_MO_V SRP
WHERE RSC.CATEGORY = OBJ.OBJECT_CODE
AND RSC.RESOURCE_ID = SRP.RESOURCE_ID(+)