[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 |
APPS.IGF_AP_EFC_MULT_FCT_V