VIEW: APPS.IGF_AP_STATE_TX_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_SLAB' , 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_SLAB'

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_SLAB'
, 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_SLAB'