VIEW: APPS.OKL_CS_PAYMENT_SCHEDULES_UV

Source

View Text - Preformatted

SELECT STMB.KHR_ID KHR_ID, STYB.CODE CODE, STYT.NAME NAME, STYB.BILLABLE_YN BILLABLE_YN, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE, SELB.AMOUNT AMOUNT, CHRB.CURRENCY_CODE FROM OKL_STRM_TYPE_TL STYT,OKL_STRM_TYPE_B STYB,OKL_STRM_ELEMENTS SELB,OKL_STREAMS STMB,OKC_K_HEADERS_B CHRB WHERE STMB.SAY_CODE = 'CURR' AND STMB.ACTIVE_YN = 'Y' AND STMB.STY_ID = STYB.ID AND STYB.ID = STYT.ID AND STYB.BILLABLE_YN = 'Y' AND STYT.LANGUAGE = USERENV('LANG') AND SELB.STM_ID = STMB.ID AND CHRB.ID = STMB.KHR_ID

View Text - HTML Formatted

SELECT STMB.KHR_ID KHR_ID
, STYB.CODE CODE
, STYT.NAME NAME
, STYB.BILLABLE_YN BILLABLE_YN
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
, SELB.AMOUNT AMOUNT
, CHRB.CURRENCY_CODE
FROM OKL_STRM_TYPE_TL STYT
, OKL_STRM_TYPE_B STYB
, OKL_STRM_ELEMENTS SELB
, OKL_STREAMS STMB
, OKC_K_HEADERS_B CHRB
WHERE STMB.SAY_CODE = 'CURR'
AND STMB.ACTIVE_YN = 'Y'
AND STMB.STY_ID = STYB.ID
AND STYB.ID = STYT.ID
AND STYB.BILLABLE_YN = 'Y'
AND STYT.LANGUAGE = USERENV('LANG')
AND SELB.STM_ID = STMB.ID
AND CHRB.ID = STMB.KHR_ID