View: JTF_RS_RESOURCES_VL

Product:	JTF - CRM Foundation
Description:	This view shows all resource including team,groups and individual resource.
Implementation/DBA Data:	APPS.JTF_RS_RESOURCES_VL

View Text

SELECT RSC.RESOURCE_ID RESOURCE_ID
, RSC.RESOURCE_NUMBER RESOURCE_NUMBER
, DECODE(RSC.CATEGORY
, 'EMPLOYEE'
, 'RS_EMPLOYEE'
, 'PARTNER'
, 'RS_PARTNER'
, 'SUPPLIER_CONTACT'
, 'RS_SUPPLIER_CONTACT'
, 'PARTY'
, 'RS_PARTY'
, 'OTHER'
, 'RS_OTHER'
, 'TBH'
, 'RS_TBH') RESOURCE_TYPE
, RSC.RESOURCE_NAME RESOURCE_NAME
, RSC.EMAIL EMAIL
, RSC.START_DATE_ACTIVE START_DATE_ACTIVE
, RSC.END_DATE_ACTIVE END_DATE_ACTIVE
, RSC.PHONE PHONE
, RSC.PERSON_PARTY_ID PERSON_PARTY_ID
, RSC.ORG_ID ORG_ID
, RSC.ORG_NAME ORG_NAME
FROM JTF_RS_RESOURCE_DTLS_VL RSC UNION ALL SELECT GRP.GROUP_ID RESOURCE_ID
, GRP.GROUP_NUMBER RESOURCE_NUMBER
, 'RS_GROUP' RESOURCE_TYPE
, GRP.GROUP_NAME RESOURCE_NAME
, GRP.EMAIL_ADDRESS EMAIL
, GRP.START_DATE_ACTIVE START_DATE_ACTIVE
, GRP.END_DATE_ACTIVE END_DATE_ACTIVE
, NULL PHONE
, TO_NUMBER(NULL) PERSON_PARTY_ID
, TO_NUMBER(NULL) ORG_ID
, NULL ORG_NAME
FROM JTF_RS_GROUPS_VL GRP UNION ALL SELECT TM.TEAM_ID RESOURCE_ID
, TM.TEAM_NUMBER RESOURCE_NUMBER
, 'RS_TEAM' RESOURCE_TYPE
, TM.TEAM_NAME RESOURCE_NAME
, TM.EMAIL_ADDRESS EMAIL
, TM.START_DATE_ACTIVE START_DATE_ACTIVE
, TM.END_DATE_ACTIVE END_DATE_ACTIVE
, NULL PHONE
, TO_NUMBER(NULL) PERSON_PARTY_ID
, TO_NUMBER(NULL) ORG_ID
, NULL ORG_NAME
FROM JTF_RS_TEAMS_VL TM

Columns