VIEW: APPS.OKL_CS_TAX_HDR_UV

Source

View Text - Preformatted

SELECT tax_hdr.khr_id contract_id, typ.NAME stream_type, selm.stream_element_date due_date , SUM(NVL(tax_hdr.assessable_value,0)) taxable_amount, SUM(NVL(tax_hdr.total_tax,0)) tax_amount, CHR.currency_code, strm.sty_id, tax_hdr.trx_id trq_id FROM okl_tax_sources tax_hdr, okc_k_headers_all_b CHR, okl_strm_type_tl typ, okl_streams strm, okl_strm_elements 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' GROUP BY tax_hdr.khr_id, typ.NAME, strm.sty_id, selm.stream_element_date, CHR.currency_code, tax_hdr.trx_id ORDER BY typ.NAME, selm.stream_element_date

View Text - HTML Formatted

SELECT TAX_HDR.KHR_ID CONTRACT_ID
, TYP.NAME STREAM_TYPE
, SELM.STREAM_ELEMENT_DATE DUE_DATE
, SUM(NVL(TAX_HDR.ASSESSABLE_VALUE
, 0)) TAXABLE_AMOUNT
, SUM(NVL(TAX_HDR.TOTAL_TAX
, 0)) TAX_AMOUNT
, CHR.CURRENCY_CODE
, STRM.STY_ID
, TAX_HDR.TRX_ID TRQ_ID
FROM OKL_TAX_SOURCES TAX_HDR
, OKC_K_HEADERS_ALL_B CHR
, OKL_STRM_TYPE_TL TYP
, OKL_STREAMS STRM
, OKL_STRM_ELEMENTS 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' GROUP BY TAX_HDR.KHR_ID
, TYP.NAME
, STRM.STY_ID
, SELM.STREAM_ELEMENT_DATE
, CHR.CURRENCY_CODE
, TAX_HDR.TRX_ID ORDER BY TYP.NAME
, SELM.STREAM_ELEMENT_DATE