View: JTF_RS_OTHER_DTLS_VL

Product:	JTF - CRM Foundation
Description:	This view has the details of all the resources whose category='OTHER'
Implementation/DBA Data:	APPS.JTF_RS_OTHER_DTLS_VL

View Text

SELECT RSC.RESOURCE_ID
, RSC.RESOURCE_NUMBER RESOURCE_NUMBER
, RSC.SOURCE_ID SOURCE_ID
, RSC.ADDRESS_ID ADDRESS_ID
, RSC.CONTACT_ID CONTACT_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.RESOURCE_NAME RESOURCE_NAME
, SRP.ORG_ID ORG_ID
, ORG.ORGANIZATION_NAME ORG_NAME
, NULL PHONE
, SRP.EMAIL_ADDRESS EMAIL
, RSC.USER_ID USER_ID
, RSC.CATEGORY
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
, JTF_RS_SALESREPS SRP
, ORG_ORGANIZATION_DEFINITIONS ORG
WHERE RSC.RESOURCE_ID = SRP.RESOURCE_ID
AND SRP.ORG_ID = ORG.ORGANIZATION_ID (+)
AND RSC.CATEGORY IN ( 'OTHER'
, 'TBH')

Columns