VIEW: APPS.JTF_TASK_RESOURCES_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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