DBA Data[Home] [Help]

VIEW: APPS.IGF_AP_EFC_FRML_C_V

Source

View Text - Preformatted

SELECT EFCC.ROWID, EFCC.CI_CAL_TYPE, EFCC.CI_SEQUENCE_NUMBER, EFCC.METHOD_CODE, NMT.METHOD_DESC, EFCC.EEA_MRD_2_WRK_RATE, EFCC.EEA_MRD_2_WRK_AMT, EFCC.EEA_MRD_1_WRK_RATE, EFCC.EEA_MRD_1_WRK_AMT, EFCC.STUD_ASSET_CONV_RATE, EFCC.CREATED_BY, EFCC.CREATION_DATE, EFCC.LAST_UPDATED_BY, EFCC.LAST_UPDATE_DATE, EFCC.LAST_UPDATE_LOGIN FROM IGF_AP_EFC_FRML_C EFCC, IGF_AP_NEED_MTH_TYP NMT WHERE NMT.METHOD_CODE = EFCC.METHOD_CODE
View Text - HTML Formatted

SELECT EFCC.ROWID
, EFCC.CI_CAL_TYPE
, EFCC.CI_SEQUENCE_NUMBER
, EFCC.METHOD_CODE
, NMT.METHOD_DESC
, EFCC.EEA_MRD_2_WRK_RATE
, EFCC.EEA_MRD_2_WRK_AMT
, EFCC.EEA_MRD_1_WRK_RATE
, EFCC.EEA_MRD_1_WRK_AMT
, EFCC.STUD_ASSET_CONV_RATE
, EFCC.CREATED_BY
, EFCC.CREATION_DATE
, EFCC.LAST_UPDATED_BY
, EFCC.LAST_UPDATE_DATE
, EFCC.LAST_UPDATE_LOGIN
FROM IGF_AP_EFC_FRML_C EFCC
, IGF_AP_NEED_MTH_TYP NMT
WHERE NMT.METHOD_CODE = EFCC.METHOD_CODE