[Home] [Help]
View: IGS_FI_GOV_HEC_PA_OP_V
View Text
SELECT GHPO.ROWID ROW_ID
, GHPO.GOVT_HECS_PAYMENT_OPTION GOVT_HECS_PAYMENT_OPTION
, GHPO.DESCRIPTION DESCRIPTION
, GHPO.S_HECS_PAYMENT_TYPE S_HECS_PAYMENT_TYPE
, GHPO.ALLOW_DISCOUNT_IND ALLOW_DISCOUNT_IND
, GHPO.CLOSED_IND CLOSED_IND
, LKUPS.MEANING MEANING
, GHPO.CREATED_BY CREATED_BY
, GHPO.CREATION_DATE CREATION_DATE
, GHPO.LAST_UPDATED_BY LAST_UPDATED_BY
, GHPO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GHPO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_FI_GOV_HEC_PA_OP GHPO
, IGS_LOOKUPS_VIEW LKUPS
WHERE LKUPS.LOOKUP_CODE = GHPO.S_HECS_PAYMENT_TYPE
AND LKUPS.LOOKUP_TYPE = 'HECS_PAYMENT_TYPE'
Columns
| Name |
| ROW_ID |
| GOVT_HECS_PAYMENT_OPTION |
| DESCRIPTION |
| S_HECS_PAYMENT_TYPE |
| ALLOW_DISCOUNT_IND |
| CLOSED_IND |
| MEANING |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |