VIEW: APPS.PER_CAGR_REFERENCE_GRADES_V

Source

View Text - Preformatted

SELECT pcg.CAGR_GRADE_ID , cgd.CAGR_GRADE_DEF_id, pcg.CAGR_GRADE_STRUCTURE_id, pcg.SEQUENCE , cgd.ID_FLEX_NUM , cgd.SUMMARY_FLAG , cgd.ENABLED_FLAG , cgd.START_DATE_active, cgd.END_DATE_ACTIVE , cgd.SEGMENT1 , cgd.SEGMENT2 , cgd.SEGMENT3 , cgd.SEGMENT4 , cgd.SEGMENT5 , cgd.SEGMENT6 , cgd.SEGMENT7 , cgd.SEGMENT8 , cgd.SEGMENT9 , cgd.SEGMENT10 , cgd.SEGMENT11 , cgd.SEGMENT12 , cgd.SEGMENT13 , cgd.SEGMENT14 , cgd.SEGMENT15 , cgd.SEGMENT16 , cgd.SEGMENT17 , cgd.SEGMENT18 , cgd.SEGMENT19 , cgd.SEGMENT20 , pcg.OBJECT_VERSION_NUMBER, pcg.LAST_UPDATE_DATE , pcg.LAST_UPDATED_BY , pcg.LAST_UPDATE_LOGIN , pcg.CREATED_BY , pcg.CREATION_DATE FROM per_cagr_grades pcg, per_cagr_grades_def cgd WHERE pcg.cagr_grade_def_id = cgd.cagr_grade_def_id

View Text - HTML Formatted

SELECT PCG.CAGR_GRADE_ID
, CGD.CAGR_GRADE_DEF_ID
, PCG.CAGR_GRADE_STRUCTURE_ID
, PCG.SEQUENCE
, CGD.ID_FLEX_NUM
, CGD.SUMMARY_FLAG
, CGD.ENABLED_FLAG
, CGD.START_DATE_ACTIVE
, CGD.END_DATE_ACTIVE
, CGD.SEGMENT1
, CGD.SEGMENT2
, CGD.SEGMENT3
, CGD.SEGMENT4
, CGD.SEGMENT5
, CGD.SEGMENT6
, CGD.SEGMENT7
, CGD.SEGMENT8
, CGD.SEGMENT9
, CGD.SEGMENT10
, CGD.SEGMENT11
, CGD.SEGMENT12
, CGD.SEGMENT13
, CGD.SEGMENT14
, CGD.SEGMENT15
, CGD.SEGMENT16
, CGD.SEGMENT17
, CGD.SEGMENT18
, CGD.SEGMENT19
, CGD.SEGMENT20
, PCG.OBJECT_VERSION_NUMBER
, PCG.LAST_UPDATE_DATE
, PCG.LAST_UPDATED_BY
, PCG.LAST_UPDATE_LOGIN
, PCG.CREATED_BY
, PCG.CREATION_DATE
FROM PER_CAGR_GRADES PCG
, PER_CAGR_GRADES_DEF CGD
WHERE PCG.CAGR_GRADE_DEF_ID = CGD.CAGR_GRADE_DEF_ID