View: OKL_PDT_ALLOWED_STREAMS_UV

Product:	OKL - Lease and Finance Management
Description:	View for Reconcile Accrual Streams during association.
Implementation/DBA Data:	APPS.OKL_PDT_ALLOWED_STREAMS_UV

View Text

SELECT DISTINCT STYT1.ID ID
, STYT1.NAME NAME
, STYT1.DESCRIPTION DESCRIPTION
, PDT1.ID PDT_ID
, PDT1.NAME PDT_NAME
, STYB1.START_DATE START_DATE
, STYB1.END_DATE END_DATE
, FND.MEANING PURPOSE
FROM OKL_PRODUCTS PDT1
, OKL_AE_TMPT_SETS AES
, OKL_AE_TEMPLATES_ALL AET
, OKL_STRM_TYPE_B STYB1
, OKL_STRM_TYPE_TL STYT1
, FND_LOOKUPS FND
WHERE PDT1.AES_ID = AES.ID
AND AES.ID = AET.AES_ID
AND STYB1.ID = AET.STY_ID
AND STYB1.ID = STYT1.ID
AND STYT1.LANGUAGE = USERENV('LANG')
AND STYB1.STREAM_TYPE_PURPOSE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE='OKL_STREAM_TYPE_PURPOSE'
AND EXISTS (SELECT '1'
FROM OKL_PRODUCTS PDT
, OKL_AE_TMPT_SETS AES
, OKL_AE_TEMPLATES_ALL AET
, OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_TL STYT
, OKL_TRX_TYPES_TL TTYT
, OKL_ST_GEN_TMPT_LNS_ALL TLN
, OKL_ST_GEN_TEMPLATES_ALL TMPT
, OKL_ST_GEN_TMPT_SETS_ALL TST
WHERE PDT.AES_ID = AES.ID
AND AES.ID = AET.AES_ID
AND AET.MEMO_YN = 'N'
AND STYB.ID = AET.STY_ID
AND STYB.ID = STYT.ID
AND STYB1.ID = STYB.ID
AND PDT1.ID = PDT.ID
AND TTYT.ID = AET.TRY_ID
AND TTYT.NAME = 'ACCRUAL'
AND TLN.GTT_ID = TMPT.ID
AND TMPT.GTS_ID = TST.ID
AND TST.ID = AES.GTS_ID
AND TLN.DEPENDENT_STY_ID = STYB.ID
AND STYB1.ACCRUAL_YN <> 'CASH_RECEIPT'
AND SYSDATE BETWEEN TRUNC(AET.START_DATE)
AND NVL(TRUNC(AET.END_DATE)
, SYSDATE)
AND TTYT.LANGUAGE = USERENV('LANG')
AND STYT.LANGUAGE = USERENV('LANG') ) UNION ALL SELECT DISTINCT STYT1.ID ID
, STYT1.NAME NAME
, STYT1.DESCRIPTION DESCRIPTION
, PDT1.ID PDT_ID
, PDT1.NAME PDT_NAME
, STYB1.START_DATE START_DATE
, STYB1.END_DATE END_DATE
, FND.MEANING PURPOSE
FROM OKL_STRM_TYPE_B STYB1
, OKL_PRODUCTS PDT1
, OKL_AE_TMPT_SETS AES
, OKL_AE_TEMPLATES_ALL AET
, OKL_STRM_TYPE_TL STYT1
, FND_LOOKUPS FND
WHERE PDT1.AES_ID = AES.ID
AND AES.ID = AET.AES_ID
AND STYB1.ID = AET.STY_ID
AND STYB1.ID = STYT1.ID
AND STYT1.LANGUAGE = USERENV('LANG')
AND STYB1.STREAM_TYPE_PURPOSE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE='OKL_STREAM_TYPE_PURPOSE'
AND EXISTS (SELECT '1'
FROM OKL_PRODUCTS PDT
, OKL_AE_TMPT_SETS AES
, OKL_AE_TEMPLATES_ALL AET
, OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_TL STYT
, OKL_TRX_TYPES_TL TTYT
, OKL_ST_GEN_TMPT_LNS_ALL TLN
, OKL_ST_GEN_TEMPLATES_ALL TMPT
, OKL_ST_GEN_TMPT_SETS_ALL TST
WHERE PDT.AES_ID = AES.ID
AND AES.ID = AET.AES_ID
AND AET.MEMO_YN = 'N'
AND STYB.ID = AET.STY_ID
AND STYB.ID = STYT.ID
AND STYB1.ID = STYB.ID
AND PDT1.ID = PDT.ID
AND TTYT.ID = AET.TRY_ID
AND TTYT.NAME = 'ACCRUAL'
AND TLN.GTT_ID = TMPT.ID
AND TMPT.GTS_ID = TST.ID
AND TST.ID = AES.GTS_ID
AND TLN.PRIMARY_STY_ID = STYB.ID
AND STYB1.ACCRUAL_YN <> 'CASH_RECEIPT'
AND SYSDATE BETWEEN TRUNC(AET.START_DATE)
AND NVL(TRUNC(AET.END_DATE)
, SYSDATE)
AND TTYT.LANGUAGE = USERENV('LANG')
AND STYT.LANGUAGE = USERENV('LANG'))

Columns