VIEW: APPS.JTF_RS_DBI_UNSEC_GRPS_V

Source

View Text - Preformatted

SELECT /*+ FIRST_ROWS */ grp2.group_name VALUE ,grp1.group_id id ,grp1.start_date_active START_DATE ,nvl(grp1.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR')) end_date ,usg.usage usage FROM jtf_rs_group_usages usg ,jtf_rs_groups_b grp1 ,jtf_rs_groups_tl grp2 WHERE usg.group_id = grp1.group_id AND usg.group_id = grp2.group_id AND grp2.LANGUAGE = USERENV('LANG')
   

View Text - HTML Formatted

SELECT /*+ FIRST_ROWS */ GRP2.GROUP_NAME VALUE
, GRP1.GROUP_ID ID
, GRP1.START_DATE_ACTIVE START_DATE
, NVL(GRP1.END_DATE_ACTIVE
, TO_DATE('12/31/4712'
, 'MM/DD/RRRR')) END_DATE
, USG.USAGE USAGE
FROM JTF_RS_GROUP_USAGES USG
, JTF_RS_GROUPS_B GRP1
, JTF_RS_GROUPS_TL GRP2
WHERE USG.GROUP_ID = GRP1.GROUP_ID
AND USG.GROUP_ID = GRP2.GROUP_ID
AND GRP2.LANGUAGE = USERENV('LANG')