VIEW: APPS.JTF_RS_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.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

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.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