VIEW: APPS.IGF_AP_INC_PRCT_V

Source

View Text - Preformatted

SELECT Efcmv.ROW_ID,Efcmv.Ci_Cal_Type,Efcmv.Ci_Sequence_Number,Efcmv.Ci_Alternate_Code,Efcmv.Ci_Start_Dt,Efcmv.Ci_End_Dt,Efcmv.Method_code,Efcmv.Method_desc,Lkup.Lookup_code,Igf_aw_gen.lookup_desc('IGF_AP_EFC_TABLE_ALLOW', lkup.lookup_code),Efcmv.CREATED_BY,Efcmv.CREATION_DATE, Efcmv.LAST_UPDATED_BY, Efcmv.LAST_UPDATE_DATE,Efcmv.LAST_UPDATE_LOGIN From Igf_Ap_Efc_Mult_Fct_V Efcmv, Igf_lookups_view lkup WHERE lkup.lookup_type = 'IGF_AP_EFC_TABLE_ALLOW'

View Text - HTML Formatted

SELECT EFCMV.ROW_ID
, EFCMV.CI_CAL_TYPE
, EFCMV.CI_SEQUENCE_NUMBER
, EFCMV.CI_ALTERNATE_CODE
, EFCMV.CI_START_DT
, EFCMV.CI_END_DT
, EFCMV.METHOD_CODE
, EFCMV.METHOD_DESC
, LKUP.LOOKUP_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_EFC_TABLE_ALLOW'
, LKUP.LOOKUP_CODE)
, EFCMV.CREATED_BY
, EFCMV.CREATION_DATE
, EFCMV.LAST_UPDATED_BY
, EFCMV.LAST_UPDATE_DATE
, EFCMV.LAST_UPDATE_LOGIN
FROM IGF_AP_EFC_MULT_FCT_V EFCMV
, IGF_LOOKUPS_VIEW LKUP
WHERE LKUP.LOOKUP_TYPE = 'IGF_AP_EFC_TABLE_ALLOW'