Skip to content
[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 |
APPS.GMS_TERMS_CONDITIONS_V