VIEW: APPS.OKL_STRMTYP_SOURCE_V

Source

View Text - Preformatted

SELECT STYB.ID ID1, '#' ID2, STYT.NAME NAME, STYT.DESCRIPTION DESCRIPTION, STYB.VERSION VERSION, STYB.CODE CODE, STYB.STREAM_TYPE_SCOPE STREAM_TYPE_SCOPE, STYB.START_DATE START_DATE_ACTIVE, STYB.END_DATE END_DATE_ACTIVE, DECODE(SIGN(trunc(sysdate)-NVL(trunc(STYB.START_DATE),trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(trunc(STYB.END_DATE),trunc(sysdate))), 1,'I','A')) STATUS, Null PRIMARY_UOM_CODE, STYB.BILLABLE_YN BILLABLE_YN, STYB.TAXABLE_DEFAULT_YN TAXABLE_DEFAULT_YN, STYB.CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL, STYB.FUNDABLE_YN FUNDABLE_YN, STYB.PERIODIC_YN PERIODIC_YN, STYB.STREAM_TYPE_CLASS STREAM_TYPE_CLASS, STYB.CAPITALIZE_YN CAPITALIZE_YN, STYB.ACCRUAL_YN ACCRUAL_YN, STYB.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE FROM OKL_STRM_TYPE_B STYB,OKL_STRM_TYPE_TL STYT WHERE STYB.ID = STYT.ID and STYT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT STYB.ID ID1
, '#' ID2
, STYT.NAME NAME
, STYT.DESCRIPTION DESCRIPTION
, STYB.VERSION VERSION
, STYB.CODE CODE
, STYB.STREAM_TYPE_SCOPE STREAM_TYPE_SCOPE
, STYB.START_DATE START_DATE_ACTIVE
, STYB.END_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(TRUNC(STYB.START_DATE)
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(TRUNC(STYB.END_DATE)
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
, STYB.BILLABLE_YN BILLABLE_YN
, STYB.TAXABLE_DEFAULT_YN TAXABLE_DEFAULT_YN
, STYB.CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL
, STYB.FUNDABLE_YN FUNDABLE_YN
, STYB.PERIODIC_YN PERIODIC_YN
, STYB.STREAM_TYPE_CLASS STREAM_TYPE_CLASS
, STYB.CAPITALIZE_YN CAPITALIZE_YN
, STYB.ACCRUAL_YN ACCRUAL_YN
, STYB.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE
FROM OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_TL STYT
WHERE STYB.ID = STYT.ID
AND STYT.LANGUAGE = USERENV('LANG')