VIEW: APPS.OKL_BPD_VAR_INT_PROCESS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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