VIEW: APPS.IGF_SE_AUTHORIZATION_V

Source

View Text - Preformatted

SELECT SE.AUTH_ID AUTHORIZATION_ID, SE.PERSON_ID PERSON_ID, SE.ACCEPTED_AMNT AUTHORIZED_AMT, SE.AUTHORIZATION_DATE, SE.FIRST_NAME PERSON_FIRST_NAME_TXT, SE.LAST_NAME PERSON_LAST_NAME_TXT, SE.BIRTH_DT BIRTH_DATE, SE.SSN_NO SOCIAL_SECURITY_NUMBER, SE.FUND_ID, FM.FUND_CODE FUND_CODE_TXT, LK1.LOOKUP_CODE SYSTEM_FUND_SOURCE_CODE, LK1.MEANING SYSTEM_FUND_SOURCE_NAME, FC.FUND_TYPE FUND_TYPE_TXT, FC.SYS_FUND_TYPE SYSTEM_FUND_TYPE_CODE, LK2.MEANING SYSTEM_FUND_TYPE_NAME, SE.AW_CAL_TYPE, SE.AW_SEQUENCE_NUMBER, IGF_SL_LAR_CREATION.get_loan_start_dt(SE.AWARD_ID) AUTHORIZATION_START_DATE, IGF_SL_LAR_CREATION.get_loan_end_dt(SE.AWARD_ID) AUTHORIZATION_END_DATE FROM IGF_SE_AUTH SE, IGF_AW_FUND_MAST_ALL FM, IGF_AW_FUND_CAT FC, IGF_LOOKUPS_VIEW LK1, IGF_LOOKUPS_VIEW LK2 WHERE FM.FUND_ID = SE.FUND_ID AND FM.FUND_CODE = FC.FUND_CODE AND FC.FUND_SOURCE = LK1.LOOKUP_CODE AND LK1.LOOKUP_TYPE = 'IGF_AW_FUND_SOURCE' AND LK2.LOOKUP_CODE = FC.SYS_FUND_TYPE AND LK2.LOOKUP_TYPE = 'IGF_AW_SYS_FUND_TYPE' AND SE.FLAG = 'A'

View Text - HTML Formatted

SELECT SE.AUTH_ID AUTHORIZATION_ID
, SE.PERSON_ID PERSON_ID
, SE.ACCEPTED_AMNT AUTHORIZED_AMT
, SE.AUTHORIZATION_DATE
, SE.FIRST_NAME PERSON_FIRST_NAME_TXT
, SE.LAST_NAME PERSON_LAST_NAME_TXT
, SE.BIRTH_DT BIRTH_DATE
, SE.SSN_NO SOCIAL_SECURITY_NUMBER
, SE.FUND_ID
, FM.FUND_CODE FUND_CODE_TXT
, LK1.LOOKUP_CODE SYSTEM_FUND_SOURCE_CODE
, LK1.MEANING SYSTEM_FUND_SOURCE_NAME
, FC.FUND_TYPE FUND_TYPE_TXT
, FC.SYS_FUND_TYPE SYSTEM_FUND_TYPE_CODE
, LK2.MEANING SYSTEM_FUND_TYPE_NAME
, SE.AW_CAL_TYPE
, SE.AW_SEQUENCE_NUMBER
, IGF_SL_LAR_CREATION.GET_LOAN_START_DT(SE.AWARD_ID) AUTHORIZATION_START_DATE
, IGF_SL_LAR_CREATION.GET_LOAN_END_DT(SE.AWARD_ID) AUTHORIZATION_END_DATE
FROM IGF_SE_AUTH SE
, IGF_AW_FUND_MAST_ALL FM
, IGF_AW_FUND_CAT FC
, IGF_LOOKUPS_VIEW LK1
, IGF_LOOKUPS_VIEW LK2
WHERE FM.FUND_ID = SE.FUND_ID
AND FM.FUND_CODE = FC.FUND_CODE
AND FC.FUND_SOURCE = LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE = 'IGF_AW_FUND_SOURCE'
AND LK2.LOOKUP_CODE = FC.SYS_FUND_TYPE
AND LK2.LOOKUP_TYPE = 'IGF_AW_SYS_FUND_TYPE'
AND SE.FLAG = 'A'