[Home] [Help]
View: IGF_AP_EFC_MULT_FCT_V
View Text
SELECT NMT.ROWID
, EFC.CI_CAL_TYPE
, EFC.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, NMT.METHOD_CODE
, NMT.METHOD_DESC
, NMT.CREATED_BY
, NMT.CREATION_DATE
, NMT.LAST_UPDATED_BY
, NMT.LAST_UPDATE_DATE
, NMT.LAST_UPDATE_LOGIN
FROM IGF_AP_EFC_V EFC
, IGF_AP_NEED_MTH_TYP NMT
, IGS_CA_INST CI
WHERE EFC.CI_CAL_TYPE = CI.CAL_TYPE
AND EFC.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
Columns
Name |
ROW_ID |
CI_CAL_TYPE |
CI_SEQUENCE_NUMBER |
CI_ALTERNATE_CODE |
CI_START_DT |
CI_END_DT |
METHOD_CODE |
METHOD_DESC |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |