SELECT pg.grade_code "Grade name" ,
pg.grade_code "Grade code",
(SELECT set_name
FROM fnd_setid_sets_vl
WHERE set_id = pg.set_id)
set_name,
TO_CHAR (pg.EFFECTIVE_START_DATE,
'DD-Mon-YYYY',
'NLS_DATE_LANGUAGE=AMERICAN')
"Effective Start Date",
pg.ACTIVE_STATUS
FROM per_grades_f pg
pg.grade_code "Grade code",
(SELECT set_name
FROM fnd_setid_sets_vl
WHERE set_id = pg.set_id)
set_name,
TO_CHAR (pg.EFFECTIVE_START_DATE,
'DD-Mon-YYYY',
'NLS_DATE_LANGUAGE=AMERICAN')
"Effective Start Date",
pg.ACTIVE_STATUS
FROM per_grades_f pg
No comments:
Post a Comment