VIEW: APPS.IGF_SL_CL_RESP_R8

Source

View Text - Preformatted

SELECT SLRESPR8.ROWID ROW_ID ,SLRESPR8.CLRP1_ID ,SLRESPR8.CLRP8_ID ,SLRESPR8.DISB_DATE ,SLRESPR8.DISB_GROSS_AMT ,SLRESPR8.ORIG_FEE ,SLRESPR8.GUARANTEE_FEE ,SLRESPR8.NET_DISB_AMT ,SLRESPR8.DISB_HOLD_REL_IND ,SLRESPR8.DISB_STATUS ,SLRESPR8.GUARNT_FEE_PAID ,SLRESPR8.ORIG_FEE_PAID ,SLRESPR8.RESP_RECORD_STATUS ,SLRESPR8.CREATED_BY ,SLRESPR8.CREATION_DATE ,SLRESPR8.LAST_UPDATED_BY ,SLRESPR8.LAST_UPDATE_DATE ,SLRESPR8.LAST_UPDATE_LOGIN ,SLRESPR8.REQUEST_ID ,SLRESPR8.PROGRAM_APPLICATION_ID ,SLRESPR8.PROGRAM_ID ,SLRESPR8.PROGRAM_UPDATE_DATE ,SLRESPR8.ORG_ID ,SLRESPR8.LAYOUT_OWNER_CODE_TXT ,SLRESPR8.LAYOUT_VERSION_CODE_TXT ,SLRESPR8.RECORD_CODE_TXT ,SLRESPR8.DIRECT_TO_BORR_FLAG FROM IGF_SL_CL_RESP_R8_ALL SLRESPR8 WHERE NVL (SLRESPR8.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 SLRESPR8.ROWID ROW_ID
, SLRESPR8.CLRP1_ID
, SLRESPR8.CLRP8_ID
, SLRESPR8.DISB_DATE
, SLRESPR8.DISB_GROSS_AMT
, SLRESPR8.ORIG_FEE
, SLRESPR8.GUARANTEE_FEE
, SLRESPR8.NET_DISB_AMT
, SLRESPR8.DISB_HOLD_REL_IND
, SLRESPR8.DISB_STATUS
, SLRESPR8.GUARNT_FEE_PAID
, SLRESPR8.ORIG_FEE_PAID
, SLRESPR8.RESP_RECORD_STATUS
, SLRESPR8.CREATED_BY
, SLRESPR8.CREATION_DATE
, SLRESPR8.LAST_UPDATED_BY
, SLRESPR8.LAST_UPDATE_DATE
, SLRESPR8.LAST_UPDATE_LOGIN
, SLRESPR8.REQUEST_ID
, SLRESPR8.PROGRAM_APPLICATION_ID
, SLRESPR8.PROGRAM_ID
, SLRESPR8.PROGRAM_UPDATE_DATE
, SLRESPR8.ORG_ID
, SLRESPR8.LAYOUT_OWNER_CODE_TXT
, SLRESPR8.LAYOUT_VERSION_CODE_TXT
, SLRESPR8.RECORD_CODE_TXT
, SLRESPR8.DIRECT_TO_BORR_FLAG
FROM IGF_SL_CL_RESP_R8_ALL SLRESPR8
WHERE NVL (SLRESPR8.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)