[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 |