[Home] [Help]
View: GMS_TERMS_CONDITIONS_V
View Text
SELECT ATC.AWARD_ID
, ATC.TERM_ID
, ATC.CATEGORY_ID
, TCC.NAME
, TC.NAME
, TC.DESCRIPTION
, ATC.OPERAND
, ATC.VALUE
, ATC.LAST_UPDATE_DATE
, ATC.LAST_UPDATED_BY
, ATC.CREATION_DATE
, ATC.CREATED_BY
, ATC.LAST_UPDATE_LOGIN
, ATC.ROWID
FROM GMS_TERMS_CONDITIONS TC
, GMS_AWARDS_TERMS_CONDITIONS ATC
, GMS_TC_CATEGORIES TCC
WHERE ATC.TERM_ID = TC.TERM_ID
AND ATC.CATEGORY_ID = TC.CATEGORY_ID
AND TCC.CATEGORY_ID = TC.CATEGORY_ID
Columns
Name |
AWARD_ID |
TERM_ID |
CATEGORY_ID |
CATEGORY_DIS |
TERM_NAME |
DESCRIPTION |
OPERAND |
VALUE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
ROW_ID |