View: JTF_RS_RESOURCE_DTLS_VL

Product:	JTF - CRM Foundation
Description:	This view is for the details (eg name , phone, email) for the resources
Implementation/DBA Data:	APPS.JTF_RS_RESOURCE_DTLS_VL

View Text

SELECT RSC.RESOURCE_ID RESOURCE_ID
, RSC.CATEGORY CATEGORY
, RSC.RESOURCE_NUMBER RESOURCE_NUMBER
, RSC.RESOURCE_NAME RESOURCE_NAME
, RSC.SOURCE_ID SOURCE_ID
, RSC.ADDRESS_ID ADDRESS_ID
, RSC.CONTACT_ID CONTACT_ID
, RSC.MANAGING_EMPLOYEE_ID MANAGING_EMPLOYEE_ID
, RSC.SUPPORT_SITE_ID SUPPORT_SITE_ID
, DECODE(RSC.CATEGORY
, 'EMPLOYEE'
, RSC.SOURCE_BUSINESS_GRP_ID
, RSC.SOURCE_ORG_ID) ORG_ID
, DECODE(RSC.CATEGORY
, 'EMPLOYEE'
, RSC.SOURCE_BUSINESS_GRP_NAME
, RSC.SOURCE_ORG_NAME ) ORG_NAME
, RSC.SOURCE_EMAIL EMAIL
, RSC.START_DATE_ACTIVE START_DATE_ACTIVE
, RSC.END_DATE_ACTIVE END_DATE_ACTIVE
, RSC.SOURCE_PHONE PHONE
, RSC.USER_ID USER_ID
, RSC.PERSON_PARTY_ID PERSON_PARTY_ID
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
WHERE RSC.CATEGORY IN ('EMPLOYEE'
, 'PARTNER'
, 'PARTY'
, 'SUPPLIER_CONTACT') UNION ALL SELECT RSC.RESOURCE_ID RESOURCE_ID
, RSC.CATEGORY CATEGOR
, RSC.RESOURCE_NUMBER RESOURCE_NUMBER
, RSC.RESOURCE_NAME RESOURCE_NAME
, RSC.SOURCE_ID SOURCE_ID
, RSC.ADDRESS_ID ADDRESS_ID
, RSC.CONTACT_ID CONTACT_ID
, RSC.MANAGING_EMPLOYEE_ID MANAGING_EMPLOYEE_ID
, RSC.SUPPORT_SITE_ID SUPPORT_SITE_ID
, SRP.ORG_ID ORG_ID
, ORG.NAME ORG_NAME
, SRP.EMAIL_ADDRESS EMAIL
, RSC.START_DATE_ACTIVE START_DATE_ACTIVE
, RSC.END_DATE_ACTIVE END_DATE_ACTIVE
, NULL PHONE
, RSC.USER_ID USER_ID
, TO_NUMBER(NULL) PARTY_ID
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
, JTF_RS_SALESREPS_MO_V SRP
, HR_ORGANIZATION_UNITS ORG
WHERE RSC.CATEGORY IN ('OTHER'
, 'TBH')
AND SRP.RESOURCE_ID = RSC.RESOURCE_ID
AND SRP.ORG_ID = ORG.ORGANIZATION_ID(+)

Columns