VIEW: APPS.GMS_TERMS_CONDITIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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