VIEW: APPS.IGF_GR_ELEC_STAT_DET

Source

View Text - Preformatted

SELECT GRDET.ROWID ROW_ID ,GRDET.ESD_ID ,GRDET.REP_PELL_ID ,GRDET.DUNS_ID ,GRDET.GAPS_AWARD_NUM ,GRDET.TRANSACTION_DATE ,GRDET.DB_CR_FLAG ,GRDET.ADJ_AMT ,GRDET.GAPS_PROCESS_DATE ,GRDET.ADJ_BATCH_ID ,GRDET.CREATED_BY ,GRDET.CREATION_DATE ,GRDET.LAST_UPDATED_BY ,GRDET.LAST_UPDATE_DATE ,GRDET.LAST_UPDATE_LOGIN ,GRDET.REQUEST_ID ,GRDET.PROGRAM_APPLICATION_ID ,GRDET.PROGRAM_ID ,GRDET.PROGRAM_UPDATE_DATE ,GRDET.ORG_ID FROM IGF_GR_ELEC_STAT_DET_ALL GRDET WHERE NVL (GRDET.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 GRDET.ROWID ROW_ID
, GRDET.ESD_ID
, GRDET.REP_PELL_ID
, GRDET.DUNS_ID
, GRDET.GAPS_AWARD_NUM
, GRDET.TRANSACTION_DATE
, GRDET.DB_CR_FLAG
, GRDET.ADJ_AMT
, GRDET.GAPS_PROCESS_DATE
, GRDET.ADJ_BATCH_ID
, GRDET.CREATED_BY
, GRDET.CREATION_DATE
, GRDET.LAST_UPDATED_BY
, GRDET.LAST_UPDATE_DATE
, GRDET.LAST_UPDATE_LOGIN
, GRDET.REQUEST_ID
, GRDET.PROGRAM_APPLICATION_ID
, GRDET.PROGRAM_ID
, GRDET.PROGRAM_UPDATE_DATE
, GRDET.ORG_ID
FROM IGF_GR_ELEC_STAT_DET_ALL GRDET
WHERE NVL (GRDET.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)