VIEW: APPS.IGF_SL_LOANS

Source

View Text - Preformatted

SELECT LAR.ROWID ROW_ID, LAR.LOAN_ID LOAN_ID , LAR.AWARD_ID AWARD_ID, LAR.SEQ_NUM SEQ_NUM, LAR.LOAN_NUMBER LOAN_NUMBER, LAR.LOAN_PER_BEGIN_DATE LOAN_PER_BEGIN_DATE, LAR.LOAN_PER_END_DATE LOAN_PER_END_DATE, LAR.LOAN_STATUS LOAN_STATUS , LAR.LOAN_STATUS_DATE LOAN_STATUS_DATE , LAR.LOAN_CHG_STATUS LOAN_CHG_STATUS , LAR.LOAN_CHG_STATUS_DATE LOAN_CHG_STATUS_DATE, LAR.ACTIVE ACTIVE , LAR.ACTIVE_DATE ACTIVE_DATE , lar.borw_detrm_code borw_detrm_code, LAR.CREATED_BY CREATED_BY , LAR.CREATION_DATE CREATION_DATE , LAR.LAST_UPDATED_BY LAST_UPDATED_BY, LAR.LAST_UPDATE_DATE LAST_UPDATE_DATE , LAR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAR.REQUEST_ID REQUEST_ID , LAR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID , LAR.PROGRAM_ID PROGRAM_ID , LAR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE , LAR.ORG_ID ORG_ID, LAR.LEGACY_RECORD_FLAG LEGACY_RECORD_FLAG, LAR.EXTERNAL_LOAN_ID_TXT EXTERNAL_LOAN_ID_TXT FROM IGF_SL_LOANS_ALL LAR WHERE NVL (LAR.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT LAR.ROWID ROW_ID
, LAR.LOAN_ID LOAN_ID
, LAR.AWARD_ID AWARD_ID
, LAR.SEQ_NUM SEQ_NUM
, LAR.LOAN_NUMBER LOAN_NUMBER
, LAR.LOAN_PER_BEGIN_DATE LOAN_PER_BEGIN_DATE
, LAR.LOAN_PER_END_DATE LOAN_PER_END_DATE
, LAR.LOAN_STATUS LOAN_STATUS
, LAR.LOAN_STATUS_DATE LOAN_STATUS_DATE
, LAR.LOAN_CHG_STATUS LOAN_CHG_STATUS
, LAR.LOAN_CHG_STATUS_DATE LOAN_CHG_STATUS_DATE
, LAR.ACTIVE ACTIVE
, LAR.ACTIVE_DATE ACTIVE_DATE
, LAR.BORW_DETRM_CODE BORW_DETRM_CODE
, LAR.CREATED_BY CREATED_BY
, LAR.CREATION_DATE CREATION_DATE
, LAR.LAST_UPDATED_BY LAST_UPDATED_BY
, LAR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAR.REQUEST_ID REQUEST_ID
, LAR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, LAR.PROGRAM_ID PROGRAM_ID
, LAR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAR.ORG_ID ORG_ID
, LAR.LEGACY_RECORD_FLAG LEGACY_RECORD_FLAG
, LAR.EXTERNAL_LOAN_ID_TXT EXTERNAL_LOAN_ID_TXT
FROM IGF_SL_LOANS_ALL LAR
WHERE NVL (LAR.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)