VIEW: APPS.CSF_RESOURCES_V

Source

View Text - Preformatted

SELECT ext_b.resource_id resource_id, ext_b.resource_number resource_number, DECODE (ext_b.category, 'EMPLOYEE', 'RS_EMPLOYEE', 'PARTNER', 'RS_PARTNER', 'SUPPLIER_CONTACT', 'RS_SUPPLIER_CONTACT', 'PARTY', 'RS_PARTY', 'OTHER', 'RS_OTHER', 'TBH', 'RS_TBH' ) resource_type, ext_t.resource_name resource_name, ext_b.start_date_active resource_start_date_active, ext_b.end_date_active resource_end_date_active FROM jtf_rs_resource_extns ext_b, jtf_rs_resource_extns_tl ext_t WHERE ext_t.LANGUAGE = USERENV ('LANG') AND ext_b.resource_id = ext_t.resource_id AND ext_b.category = ext_t.category AND ext_b.CATEGORY IN ('EMPLOYEE', 'PARTNER', 'PARTY', 'SUPPLIER_CONTACT', 'OTHER', 'TBH') UNION ALL SELECT grp_b.group_id resource_id, grp_b.group_number resource_number, 'RS_GROUP' resource_type, grp_t.group_name resource_name, grp_b.start_date_active resource_start_date_active, grp_b.end_date_active resource_end_date_active FROM jtf_rs_groups_tl grp_t, jtf_rs_groups_b grp_b WHERE grp_b.group_id = grp_t.group_id AND grp_t.LANGUAGE = USERENV ('LANG') UNION ALL SELECT tm_b.team_id resource_id, tm_b.team_number resource_number, 'RS_TEAM' resource_type, tm_t.team_name resource_name, tm_b.start_date_active resource_start_date_active, tm_b.end_date_active resource_end_date_active FROM jtf_rs_teams_tl tm_t, jtf_rs_teams_b tm_b WHERE tm_b.team_id = tm_t.team_id AND tm_t.LANGUAGE = USERENV ('LANG')

View Text - HTML Formatted

SELECT EXT_B.RESOURCE_ID RESOURCE_ID
, EXT_B.RESOURCE_NUMBER RESOURCE_NUMBER
, DECODE (EXT_B.CATEGORY
, 'EMPLOYEE'
, 'RS_EMPLOYEE'
, 'PARTNER'
, 'RS_PARTNER'
, 'SUPPLIER_CONTACT'
, 'RS_SUPPLIER_CONTACT'
, 'PARTY'
, 'RS_PARTY'
, 'OTHER'
, 'RS_OTHER'
, 'TBH'
, 'RS_TBH' ) RESOURCE_TYPE
, EXT_T.RESOURCE_NAME RESOURCE_NAME
, EXT_B.START_DATE_ACTIVE RESOURCE_START_DATE_ACTIVE
, EXT_B.END_DATE_ACTIVE RESOURCE_END_DATE_ACTIVE
FROM JTF_RS_RESOURCE_EXTNS EXT_B
, JTF_RS_RESOURCE_EXTNS_TL EXT_T
WHERE EXT_T.LANGUAGE = USERENV ('LANG')
AND EXT_B.RESOURCE_ID = EXT_T.RESOURCE_ID
AND EXT_B.CATEGORY = EXT_T.CATEGORY
AND EXT_B.CATEGORY IN ('EMPLOYEE'
, 'PARTNER'
, 'PARTY'
, 'SUPPLIER_CONTACT'
, 'OTHER'
, 'TBH') UNION ALL SELECT GRP_B.GROUP_ID RESOURCE_ID
, GRP_B.GROUP_NUMBER RESOURCE_NUMBER
, 'RS_GROUP' RESOURCE_TYPE
, GRP_T.GROUP_NAME RESOURCE_NAME
, GRP_B.START_DATE_ACTIVE RESOURCE_START_DATE_ACTIVE
, GRP_B.END_DATE_ACTIVE RESOURCE_END_DATE_ACTIVE
FROM JTF_RS_GROUPS_TL GRP_T
, JTF_RS_GROUPS_B GRP_B
WHERE GRP_B.GROUP_ID = GRP_T.GROUP_ID
AND GRP_T.LANGUAGE = USERENV ('LANG') UNION ALL SELECT TM_B.TEAM_ID RESOURCE_ID
, TM_B.TEAM_NUMBER RESOURCE_NUMBER
, 'RS_TEAM' RESOURCE_TYPE
, TM_T.TEAM_NAME RESOURCE_NAME
, TM_B.START_DATE_ACTIVE RESOURCE_START_DATE_ACTIVE
, TM_B.END_DATE_ACTIVE RESOURCE_END_DATE_ACTIVE
FROM JTF_RS_TEAMS_TL TM_T
, JTF_RS_TEAMS_B TM_B
WHERE TM_B.TEAM_ID = TM_T.TEAM_ID
AND TM_T.LANGUAGE = USERENV ('LANG')