VIEW: APPS.OKL_TAX_LINES_UV

Source

View Text - Preformatted

SELECT TAX_HDR.ID, TAX_HDR.KHR_ID CONTRACT_ID, TAX_HDR.KLE_ID CONTRACT_LINE_ID, TAX_HDR.LINE_NAME ASSET_NUMBER, NULL LINE_TYPE, TYP.NAME STREAM_TYPE, SELM.ID STREAM_ELEMENT_ID, SELM.AMOUNT STREAM_AMOUNT, SELM.STREAM_ELEMENT_DATE DUE_DATE, (SELECT DISTINCT BILLED_YN FROM OKL_TAX_TRX_DETAILS WHERE TXS_ID = TAX_HDR.ID and rownum < 2) ACTUAL_YN, NULL TAX_RATE_CODE, TAX_HDR.ASSESSABLE_VALUE TAXABLE_AMOUNT, NULL TAX_RATE, TAX_HDR.TOTAL_TAX TAX_AMOUNT, TAX_HDR.TRX_ID TRQ_ID, CHR.CURRENCY_CODE, TAX_HDR.CREATED_BY, TAX_HDR.CREATION_DATE, TAX_HDR.LAST_UPDATED_BY, TAX_HDR.LAST_UPDATE_DATE, TAX_HDR.LAST_UPDATE_LOGIN, TAX_HDR.TRX_LINE_ID TRX_LINE_ID, TAX_HDR.TAX_LINE_STATUS_CODE, TAX_HDR.TRX_LEVEL_TYPE, TAX_HDR.APPLICATION_ID, TAX_HDR.ENTITY_CODE, TAX_HDR.EVENT_CLASS_CODE, TAX_HDR.TAX_CALL_TYPE_CODE, STRM.STY_ID FROM OKL_TAX_SOURCES TAX_HDR,OKC_K_HEADERS_B CHR,OKL_STRM_TYPE_TL TYP,OKL_STREAMS_V STRM,OKL_STRM_ELEMENTS_V SELM WHERE TAX_HDR.KHR_ID = CHR.ID AND TAX_HDR.SEL_ID = SELM.ID AND SELM.STM_id = STRM.ID AND STRM.STY_ID = TYP.ID AND TYP.LANGUAGE = USERENV('LANG') AND TAX_HDR.TAX_LINE_STATUS_CODE = 'ACTIVE' AND TAX_HDR.TRX_LEVEL_TYPE = 'LINE' AND TAX_HDR.TAX_CALL_TYPE_CODE = 'TAX_SCHEDULE' AND TAX_HDR.ENTITY_CODE = 'TAX_SCHEDULE_REQUESTS' AND TAX_HDR.APPLICATION_ID = 540 AND TAX_HDR.EVENT_CLASS_CODE = 'TAX_SCHEDULE'

View Text - HTML Formatted

SELECT TAX_HDR.ID
, TAX_HDR.KHR_ID CONTRACT_ID
, TAX_HDR.KLE_ID CONTRACT_LINE_ID
, TAX_HDR.LINE_NAME ASSET_NUMBER
, NULL LINE_TYPE
, TYP.NAME STREAM_TYPE
, SELM.ID STREAM_ELEMENT_ID
, SELM.AMOUNT STREAM_AMOUNT
, SELM.STREAM_ELEMENT_DATE DUE_DATE
, (SELECT DISTINCT BILLED_YN
FROM OKL_TAX_TRX_DETAILS
WHERE TXS_ID = TAX_HDR.ID
AND ROWNUM < 2) ACTUAL_YN
, NULL TAX_RATE_CODE
, TAX_HDR.ASSESSABLE_VALUE TAXABLE_AMOUNT
, NULL TAX_RATE
, TAX_HDR.TOTAL_TAX TAX_AMOUNT
, TAX_HDR.TRX_ID TRQ_ID
, CHR.CURRENCY_CODE
, TAX_HDR.CREATED_BY
, TAX_HDR.CREATION_DATE
, TAX_HDR.LAST_UPDATED_BY
, TAX_HDR.LAST_UPDATE_DATE
, TAX_HDR.LAST_UPDATE_LOGIN
, TAX_HDR.TRX_LINE_ID TRX_LINE_ID
, TAX_HDR.TAX_LINE_STATUS_CODE
, TAX_HDR.TRX_LEVEL_TYPE
, TAX_HDR.APPLICATION_ID
, TAX_HDR.ENTITY_CODE
, TAX_HDR.EVENT_CLASS_CODE
, TAX_HDR.TAX_CALL_TYPE_CODE
, STRM.STY_ID
FROM OKL_TAX_SOURCES TAX_HDR
, OKC_K_HEADERS_B CHR
, OKL_STRM_TYPE_TL TYP
, OKL_STREAMS_V STRM
, OKL_STRM_ELEMENTS_V SELM
WHERE TAX_HDR.KHR_ID = CHR.ID
AND TAX_HDR.SEL_ID = SELM.ID
AND SELM.STM_ID = STRM.ID
AND STRM.STY_ID = TYP.ID
AND TYP.LANGUAGE = USERENV('LANG')
AND TAX_HDR.TAX_LINE_STATUS_CODE = 'ACTIVE'
AND TAX_HDR.TRX_LEVEL_TYPE = 'LINE'
AND TAX_HDR.TAX_CALL_TYPE_CODE = 'TAX_SCHEDULE'
AND TAX_HDR.ENTITY_CODE = 'TAX_SCHEDULE_REQUESTS'
AND TAX_HDR.APPLICATION_ID = 540
AND TAX_HDR.EVENT_CLASS_CODE = 'TAX_SCHEDULE'