View: OKL_GENERATE_STREAMS_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_GENERATE_STREAMS_UV

View Text

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

Columns