Product: | OKL - Lease and Finance Management |
---|---|
Description: | Variable Interest Process |
Implementation/DBA Data: | APPS.OKL_BPD_VAR_INT_PROCESS_UV |
SELECT VIP.CONTRACT_NUMBER CONTRACT_NUMBER
, VIP.REQUEST_ID REQUEST_ID
, CHR.STS_CODE CONTRACT_STATUS
, SIF1.TRANSACTION_NUMBER PARENT_TRANSACTION_NUMBER
, SIF1.ID PARENT_SIF_ID
, SIF1.SIS_CODE PARENT_SIS_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_SIF_STATUS'
, SIF1.SIS_CODE) PARENT_STATUS
, SIF1.ORP_CODE PARENT_ORP_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_ORIGINATION_PROCESS'
, SIF1.ORP_CODE) PARENT_ORIGINATING_PROCESS
, SIF1.DATE_PROCESSED PARENT_DATE_PROCESSED
, SIF1.LOG_FILE PARENT_LOG_FILE
, SIF2.TRANSACTION_NUMBER CHILD_TRANSACTION_NUMBER
, SIF2.ID CHILD_SIF_ID
, SIF2.SIS_CODE CHILD_SIS_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_SIF_STATUS'
, SIF2.SIS_CODE) CHILD_STATUS
, SIF2.ORP_CODE CHILD_ORP_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STRM_G_ORIGINATION_PROCESS'
, SIF2.ORP_CODE) CHILD_ORIGINATING_PROCESS
, SIF2.DATE_PROCESSED CHILD_DATE_PROCESSED
, SIF2.LOG_FILE CHILD_LOG_FILE
, CHR.AUTHORING_ORG_ID ORG_ID
, CHR.ID CONTRACT_ID
FROM OKL_VAR_INT_PROCESS_B VIP
, OKL_STREAM_INTERFACES SIF1
, OKL_STREAM_INTERFACES SIF2
, OKC_K_HEADERS_B CHR
WHERE SIF1.TRANSACTION_NUMBER = VIP.PARENT_TRX_ID AND SIF2.TRANSACTION_NUMBER (+) = VIP.CHILD_TRX_ID AND CHR.CONTRACT_NUMBER = VIP.CONTRACT_NUMBER