[Home] [Help]
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
Name |
RESOURCE_ID |
RESOURCE_NUMBER |
RESOURCE_TYPE |
RESOURCE_NAME |
EMAIL |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
PHONE |
PERSON_PARTY_ID |
ORG_ID |
ORG_NAME |