VIEW: APPS.IGF_SL_AWD_DISB_LOC

Source

View Text - Preformatted

SELECT AWDL.ROWID ROW_ID, AWDL.AWARD_ID AWARD_ID , AWDL.DISB_NUM DISB_NUM , AWDL.DISB_GROSS_AMT DISB_GROSS_AMT , AWDL.FEE_1 FEE_1 , AWDL.FEE_2 FEE_2 , AWDL.DISB_NET_AMT DISB_NET_AMT, AWDL.DISB_DATE DISB_DATE , AWDL.HOLD_REL_IND HOLD_REL_IND , AWDL.FEE_PAID_1 FEE_PAID_1 , AWDL.FEE_PAID_2 FEE_PAID_2 , AWDL.CREATED_BY CREATED_BY , AWDL.CREATION_DATE CREATION_DATE , AWDL.LAST_UPDATED_BY LAST_UPDATED_BY, AWDL.LAST_UPDATE_DATE LAST_UPDATE_DATE , AWDL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , AWDL.REQUEST_ID REQUEST_ID , AWDL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, AWDL.PROGRAM_ID PROGRAM_ID , AWDL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE , AWDL.ORG_ID ORG_ID FROM IGF_SL_AWD_DISB_LOC_ALL AWDL WHERE NVL (AWDL.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 AWDL.ROWID ROW_ID
, AWDL.AWARD_ID AWARD_ID
, AWDL.DISB_NUM DISB_NUM
, AWDL.DISB_GROSS_AMT DISB_GROSS_AMT
, AWDL.FEE_1 FEE_1
, AWDL.FEE_2 FEE_2
, AWDL.DISB_NET_AMT DISB_NET_AMT
, AWDL.DISB_DATE DISB_DATE
, AWDL.HOLD_REL_IND HOLD_REL_IND
, AWDL.FEE_PAID_1 FEE_PAID_1
, AWDL.FEE_PAID_2 FEE_PAID_2
, AWDL.CREATED_BY CREATED_BY
, AWDL.CREATION_DATE CREATION_DATE
, AWDL.LAST_UPDATED_BY LAST_UPDATED_BY
, AWDL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AWDL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AWDL.REQUEST_ID REQUEST_ID
, AWDL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AWDL.PROGRAM_ID PROGRAM_ID
, AWDL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AWDL.ORG_ID ORG_ID
FROM IGF_SL_AWD_DISB_LOC_ALL AWDL
WHERE NVL (AWDL.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)