View: JTF_TASK_RESOURCES_VL

Product:	JTF - CRM Foundation
Description:
Implementation/DBA Data:	APPS.JTF_TASK_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.SOURCE_EMAIL EMAIL
, RSC.START_DATE_ACTIVE START_DATE_ACTIVE
, RSC.END_DATE_ACTIVE END_DATE_ACTIVE
, RSC.SOURCE_PHONE PHONE
, RSC.PERSON_PARTY_ID PERSON_PARTY_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 FROM JTF_RS_RESOURCE_EXTNS_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