VIEW: APPS.OKL_GENERATE_STREAMS_UV

Source

View Text - Preformatted

SELECT KHRB.ID CONTRACT_ID, KHRB.CONTRACT_NUMBER CONTRACT_NUMBER, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER, SIFB2.TRANSACTION_NUMBER REPORT_TRANSACTION_NUMBER, SIFB.ID SIF_ID, Okl_Accounting_Util.GET_LOOKUP_MEANING( 'OKL_SIF_STATUS', SIFB.SIS_CODE) STATUS, Okl_Accounting_Util.GET_LOOKUP_MEANING( 'OKL_SIF_STATUS', SIFB2.SIS_CODE) REPORT_STATUS, Okl_Accounting_Util.GET_LOOKUP_MEANING( 'OKL_STRM_G_ORIGINATION_PROCESS', SIFB.ORP_CODE) ORIGINATING_PROCESS , SIFB.PURPOSE_CODE PURPOSE_CODE, SIFB.DATE_PROCESSED DATE_PROCESSED , SIFB.SIS_CODE SIS_CODE ,SIFB.LOG_FILE LOG_FILE ,SIFB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01 ,SIFB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02 ,SIFB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03 ,SIFB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04 ,SIFB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05 ,SIFB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06 ,SIFB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07 ,SIFB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08 ,SIFB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09 ,SIFB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10 ,SIFB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11 ,SIFB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12 ,SIFB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13 ,SIFB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14 ,SIFB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15 ,SIFB2.SIS_CODE REP_SIS_CODE FROM OKC_K_HEADERS_B KHRB,OKL_STREAM_INTERFACES SIFB,OKL_STREAM_INTERFACES SIFB2 WHERE KHRB.ID = SIFB.KHR_ID AND SIFB.ID = SIFB2.SIF_ID (+) AND SIFB.SIF_ID IS NULL

View Text - HTML Formatted

SELECT KHRB.ID CONTRACT_ID
, KHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, SIFB2.TRANSACTION_NUMBER REPORT_TRANSACTION_NUMBER
, SIFB.ID SIF_ID
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_SIF_STATUS'
, SIFB.SIS_CODE) STATUS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_SIF_STATUS'
, SIFB2.SIS_CODE) REPORT_STATUS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STRM_G_ORIGINATION_PROCESS'
, SIFB.ORP_CODE) ORIGINATING_PROCESS
, SIFB.PURPOSE_CODE PURPOSE_CODE
, SIFB.DATE_PROCESSED DATE_PROCESSED
, SIFB.SIS_CODE SIS_CODE
, SIFB.LOG_FILE LOG_FILE
, SIFB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01
, SIFB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02
, SIFB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03
, SIFB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04
, SIFB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05
, SIFB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06
, SIFB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07
, SIFB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08
, SIFB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09
, SIFB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10
, SIFB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11
, SIFB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12
, SIFB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13
, SIFB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14
, SIFB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15
, SIFB2.SIS_CODE REP_SIS_CODE
FROM OKC_K_HEADERS_B KHRB
, OKL_STREAM_INTERFACES SIFB
, OKL_STREAM_INTERFACES SIFB2
WHERE KHRB.ID = SIFB.KHR_ID
AND SIFB.ID = SIFB2.SIF_ID (+)
AND SIFB.SIF_ID IS NULL