VIEW: APPS.OKL_SIF_TRX_PARMS_UV

Source

View Text - Preformatted

SELECT DISTINCT SXPB.SPP_ID SPP_ID, SXPB.SIF_ID SIF_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, SPPB.NAME NAME, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_PRICE_PARAMS_SPS_CODE',SPPB.SPS_CODE) SCOPE, SXPB.KLE_ID KLE_ID, '-' ASSET_NAME, SPPB.ARRAY_YN ARRAY_YN, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO',SPPB.ARRAY_YN,0,0) ARRAY_YES_NO , SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER FROM OKL_STREAM_INTERFACES SIFB,OKL_SIF_TRX_PARMS SXPB,OKL_SIF_PRICE_PARMS SPPB,OKC_K_HEADERS_B CHRB WHERE SPPB.ID = SXPB.SPP_ID AND SXPB.KHR_ID = CHRB.ID AND SXPB.KLE_ID IS NULL AND SXPB.SIF_ID = SIFB.ID UNION ALL SELECT DISTINCT SXPB.SPP_ID SPP_ID, SXPB.SIF_ID SIF_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, SPPB.NAME NAME, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_PRICE_PARAMS_SPS_CODE',SPPB.SPS_CODE) SCOPE, SXPB.KLE_ID KLE_ID, NVL(CLET.NAME, '-') ASSET_NAME, SPPB.ARRAY_YN ARRAY_YN, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO',SPPB.ARRAY_YN,0,0) ARRAY_YES_NO , SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER FROM OKL_SIF_TRX_PARMS SXPB, OKL_SIF_PRICE_PARMS SPPB, OKC_K_HEADERS_B CHRB, OKC_K_LINES_B CLEB, OKC_LINE_STYLES_B LSEB, OKL_STREAM_INTERFACES SIFB, OKC_K_LINES_TL CLET WHERE SPPB.ID = SXPB.SPP_ID AND SXPB.KHR_ID = CHRB.ID AND SXPB.KLE_ID = CLEB.ID AND CLEB.DNZ_CHR_ID = CHRB.ID AND CLEB.LSE_ID = LSEB.ID AND SXPB.SIF_ID = SIFB.ID AND LSEB.LTY_CODE = 'FREE_FORM1' AND CLET.ID = CLEB.ID AND CLET.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT DISTINCT SXPB.SPP_ID SPP_ID
, SXPB.SIF_ID SIF_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, SPPB.NAME NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_PRICE_PARAMS_SPS_CODE'
, SPPB.SPS_CODE) SCOPE
, SXPB.KLE_ID KLE_ID
, '-' ASSET_NAME
, SPPB.ARRAY_YN ARRAY_YN
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SPPB.ARRAY_YN
, 0
, 0) ARRAY_YES_NO
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
FROM OKL_STREAM_INTERFACES SIFB
, OKL_SIF_TRX_PARMS SXPB
, OKL_SIF_PRICE_PARMS SPPB
, OKC_K_HEADERS_B CHRB
WHERE SPPB.ID = SXPB.SPP_ID
AND SXPB.KHR_ID = CHRB.ID
AND SXPB.KLE_ID IS NULL
AND SXPB.SIF_ID = SIFB.ID UNION ALL SELECT DISTINCT SXPB.SPP_ID SPP_ID
, SXPB.SIF_ID SIF_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, SPPB.NAME NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_PRICE_PARAMS_SPS_CODE'
, SPPB.SPS_CODE) SCOPE
, SXPB.KLE_ID KLE_ID
, NVL(CLET.NAME
, '-') ASSET_NAME
, SPPB.ARRAY_YN ARRAY_YN
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SPPB.ARRAY_YN
, 0
, 0) ARRAY_YES_NO
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
FROM OKL_SIF_TRX_PARMS SXPB
, OKL_SIF_PRICE_PARMS SPPB
, OKC_K_HEADERS_B CHRB
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSEB
, OKL_STREAM_INTERFACES SIFB
, OKC_K_LINES_TL CLET
WHERE SPPB.ID = SXPB.SPP_ID
AND SXPB.KHR_ID = CHRB.ID
AND SXPB.KLE_ID = CLEB.ID
AND CLEB.DNZ_CHR_ID = CHRB.ID
AND CLEB.LSE_ID = LSEB.ID
AND SXPB.SIF_ID = SIFB.ID
AND LSEB.LTY_CODE = 'FREE_FORM1'
AND CLET.ID = CLEB.ID
AND CLET.LANGUAGE = USERENV('LANG')