VIEW: APPS.JTF_TERR_QLFY_RSC_DST_V

Source

View Text - Preformatted

SELECT rsc.resource_id RESOURCE_ID , 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 , DECODE( rsc.category , 'EMPLOYEE', 'Employee Resource' , 'PARTNER', 'Partner Resource' , 'SUPPLIER_CONTACT', 'Supplier Resource' , 'PARTY', 'Party Resource' , 'OTHER', 'Other Resource' , 'TBH', 'To be hired') resource_type_name , rsc.resource_name RESOURCE_NAME , NULL, NULL, NULL, NULL FROM jtf_rs_resource_extns_vl rsc WHERE NVL(rsc.end_date_active, SYSDATE+1) > SYSDATE AND rsc.start_date_active <= SYSDATE UNION ALL SELECT grp.group_id RESOURCE_ID , 'RS_GROUP' RESOURCE_TYPE , 'Group Resource' RESOURCE_TYPE_NAME , grp.group_name RESOURCE_NAME , NULL, NULL, NULL, NULL FROM jtf_rs_groups_vl grp WHERE NVL(grp.start_date_active, SYSDATE-1) <= SYSDATE AND NVL(grp.end_date_active, SYSDATE+1) >= SYSDATE UNION ALL SELECT tm.team_id RESOURCE_ID , 'RS_TEAM' RESOURCE_TYPE , 'Team Resource' RESOURCE_TYPE_NAME , tm.team_name RESOURCE_NAME , NULL, NULL, NULL, NULL FROM jtf_rs_teams_vl tm WHERE NVL(tm.start_date_active, SYSDATE-1) <= SYSDATE AND NVL(tm.end_date_active, SYSDATE+1) >= SYSDATE

View Text - HTML Formatted

SELECT RSC.RESOURCE_ID RESOURCE_ID
, 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
, DECODE( RSC.CATEGORY
, 'EMPLOYEE'
, 'EMPLOYEE RESOURCE'
, 'PARTNER'
, 'PARTNER RESOURCE'
, 'SUPPLIER_CONTACT'
, 'SUPPLIER RESOURCE'
, 'PARTY'
, 'PARTY RESOURCE'
, 'OTHER'
, 'OTHER RESOURCE'
, 'TBH'
, 'TO BE HIRED') RESOURCE_TYPE_NAME
, RSC.RESOURCE_NAME RESOURCE_NAME
, NULL
, NULL
, NULL
, NULL
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
WHERE NVL(RSC.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND RSC.START_DATE_ACTIVE <= SYSDATE UNION ALL SELECT GRP.GROUP_ID RESOURCE_ID
, 'RS_GROUP' RESOURCE_TYPE
, 'GROUP RESOURCE' RESOURCE_TYPE_NAME
, GRP.GROUP_NAME RESOURCE_NAME
, NULL
, NULL
, NULL
, NULL
FROM JTF_RS_GROUPS_VL GRP
WHERE NVL(GRP.START_DATE_ACTIVE
, SYSDATE-1) <= SYSDATE
AND NVL(GRP.END_DATE_ACTIVE
, SYSDATE+1) >= SYSDATE UNION ALL SELECT TM.TEAM_ID RESOURCE_ID
, 'RS_TEAM' RESOURCE_TYPE
, 'TEAM RESOURCE' RESOURCE_TYPE_NAME
, TM.TEAM_NAME RESOURCE_NAME
, NULL
, NULL
, NULL
, NULL
FROM JTF_RS_TEAMS_VL TM
WHERE NVL(TM.START_DATE_ACTIVE
, SYSDATE-1) <= SYSDATE
AND NVL(TM.END_DATE_ACTIVE
, SYSDATE+1) >= SYSDATE