VIEW: APPS.PER_GRADES_API_V

Source

View Text - Preformatted

SELECT GRD.GRADE_ID,GRD.BUSINESS_GROUP_ID,GRD.DATE_FROM,GRD.SEQUENCE,GRD.COMMENTS,GRD.DATE_TO,GRD.NAME,GRD.REQUEST_ID,GRD.PROGRAM_APPLICATION_ID,GRD.PROGRAM_ID,GRD.PROGRAM_UPDATE_DATE,GRD.ATTRIBUTE_CATEGORY,GRD.ATTRIBUTE1,GRD.ATTRIBUTE2,GRD.ATTRIBUTE3,GRD.ATTRIBUTE4,GRD.ATTRIBUTE5,GRD.ATTRIBUTE6,GRD.ATTRIBUTE7,GRD.ATTRIBUTE8,GRD.ATTRIBUTE9,GRD.ATTRIBUTE10,GRD.ATTRIBUTE11,GRD.ATTRIBUTE12,GRD.ATTRIBUTE13,GRD.ATTRIBUTE14,GRD.ATTRIBUTE15,GRD.ATTRIBUTE16,GRD.ATTRIBUTE17,GRD.ATTRIBUTE18,GRD.ATTRIBUTE19,GRD.ATTRIBUTE20,GRD.LAST_UPDATE_DATE,GRD.LAST_UPDATED_BY,GRD.LAST_UPDATE_LOGIN,GRD.CREATED_BY,GRD.CREATION_DATE,GDF.GRADE_DEFINITION_ID,GDF.REQUEST_ID,GDF.PROGRAM_APPLICATION_ID,GDF.PROGRAM_ID,GDF.PROGRAM_UPDATE_DATE,GDF.ID_FLEX_NUM,GDF.SUMMARY_FLAG,GDF.ENABLED_FLAG,GDF.START_DATE_ACTIVE,GDF.END_DATE_ACTIVE,GDF.SEGMENT1,GDF.SEGMENT2,GDF.SEGMENT3,GDF.SEGMENT4,GDF.SEGMENT5,GDF.SEGMENT6,GDF.SEGMENT7,GDF.SEGMENT8,GDF.SEGMENT9,GDF.SEGMENT10,GDF.SEGMENT11,GDF.SEGMENT12,GDF.SEGMENT13,GDF.SEGMENT14,GDF.SEGMENT15,GDF.SEGMENT16,GDF.SEGMENT17,GDF.SEGMENT18,GDF.SEGMENT19,GDF.SEGMENT20,GDF.SEGMENT21,GDF.SEGMENT22,GDF.SEGMENT23,GDF.SEGMENT24,GDF.SEGMENT25,GDF.SEGMENT26,GDF.SEGMENT27,GDF.SEGMENT28,GDF.SEGMENT29,GDF.SEGMENT30,GDF.OBJECT_VERSION_NUMBER,GRD.INFORMATION_CATEGORY,GRD.INFORMATION1,GRD.INFORMATION2,GRD.INFORMATION3,GRD.INFORMATION4,GRD.INFORMATION5,GRD.INFORMATION6,GRD.INFORMATION7,GRD.INFORMATION8,GRD.INFORMATION9,GRD.INFORMATION10,GRD.INFORMATION11,GRD.INFORMATION12,GRD.INFORMATION13,GRD.INFORMATION14,GRD.INFORMATION15,GRD.INFORMATION16,GRD.INFORMATION17,GRD.INFORMATION18,GRD.INFORMATION19,GRD.INFORMATION20,GRD.OBJECT_VERSION_NUMBER FROM PER_GRADES GRD,PER_GRADE_DEFINITIONS GDF WHERE GRD.GRADE_DEFINITION_ID = GDF.GRADE_DEFINITION_ID

View Text - HTML Formatted

SELECT GRD.GRADE_ID
, GRD.BUSINESS_GROUP_ID
, GRD.DATE_FROM
, GRD.SEQUENCE
, GRD.COMMENTS
, GRD.DATE_TO
, GRD.NAME
, GRD.REQUEST_ID
, GRD.PROGRAM_APPLICATION_ID
, GRD.PROGRAM_ID
, GRD.PROGRAM_UPDATE_DATE
, GRD.ATTRIBUTE_CATEGORY
, GRD.ATTRIBUTE1
, GRD.ATTRIBUTE2
, GRD.ATTRIBUTE3
, GRD.ATTRIBUTE4
, GRD.ATTRIBUTE5
, GRD.ATTRIBUTE6
, GRD.ATTRIBUTE7
, GRD.ATTRIBUTE8
, GRD.ATTRIBUTE9
, GRD.ATTRIBUTE10
, GRD.ATTRIBUTE11
, GRD.ATTRIBUTE12
, GRD.ATTRIBUTE13
, GRD.ATTRIBUTE14
, GRD.ATTRIBUTE15
, GRD.ATTRIBUTE16
, GRD.ATTRIBUTE17
, GRD.ATTRIBUTE18
, GRD.ATTRIBUTE19
, GRD.ATTRIBUTE20
, GRD.LAST_UPDATE_DATE
, GRD.LAST_UPDATED_BY
, GRD.LAST_UPDATE_LOGIN
, GRD.CREATED_BY
, GRD.CREATION_DATE
, GDF.GRADE_DEFINITION_ID
, GDF.REQUEST_ID
, GDF.PROGRAM_APPLICATION_ID
, GDF.PROGRAM_ID
, GDF.PROGRAM_UPDATE_DATE
, GDF.ID_FLEX_NUM
, GDF.SUMMARY_FLAG
, GDF.ENABLED_FLAG
, GDF.START_DATE_ACTIVE
, GDF.END_DATE_ACTIVE
, GDF.SEGMENT1
, GDF.SEGMENT2
, GDF.SEGMENT3
, GDF.SEGMENT4
, GDF.SEGMENT5
, GDF.SEGMENT6
, GDF.SEGMENT7
, GDF.SEGMENT8
, GDF.SEGMENT9
, GDF.SEGMENT10
, GDF.SEGMENT11
, GDF.SEGMENT12
, GDF.SEGMENT13
, GDF.SEGMENT14
, GDF.SEGMENT15
, GDF.SEGMENT16
, GDF.SEGMENT17
, GDF.SEGMENT18
, GDF.SEGMENT19
, GDF.SEGMENT20
, GDF.SEGMENT21
, GDF.SEGMENT22
, GDF.SEGMENT23
, GDF.SEGMENT24
, GDF.SEGMENT25
, GDF.SEGMENT26
, GDF.SEGMENT27
, GDF.SEGMENT28
, GDF.SEGMENT29
, GDF.SEGMENT30
, GDF.OBJECT_VERSION_NUMBER
, GRD.INFORMATION_CATEGORY
, GRD.INFORMATION1
, GRD.INFORMATION2
, GRD.INFORMATION3
, GRD.INFORMATION4
, GRD.INFORMATION5
, GRD.INFORMATION6
, GRD.INFORMATION7
, GRD.INFORMATION8
, GRD.INFORMATION9
, GRD.INFORMATION10
, GRD.INFORMATION11
, GRD.INFORMATION12
, GRD.INFORMATION13
, GRD.INFORMATION14
, GRD.INFORMATION15
, GRD.INFORMATION16
, GRD.INFORMATION17
, GRD.INFORMATION18
, GRD.INFORMATION19
, GRD.INFORMATION20
, GRD.OBJECT_VERSION_NUMBER
FROM PER_GRADES GRD
, PER_GRADE_DEFINITIONS GDF
WHERE GRD.GRADE_DEFINITION_ID = GDF.GRADE_DEFINITION_ID