VIEW: APPS.OKL_PDT_ALLOWED_STREAMS_UV

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))