[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT asset.chr_id CHR_ID,
asset.id KLE_ID
FROM okc_k_headers_b chr,
okl_k_lines_full_v asset ,
okc_line_styles_b ls
WHERE chr.contract_number BETWEEN NVL(cp_cont_num_from,chr.contract_number) AND NVL(cp_cont_num_to,chr.contract_number)
AND asset.chr_id = chr.id
AND asset.name BETWEEN NVL(cp_asset_name_from,asset.name) AND NVL(cp_asset_name_to,asset.name)
AND ls.id = asset.lse_id
AND ls.lty_code = 'FREE_FORM1';
SELECT khr.contract_number,
asset.name,
ptv.JURSDCTN_NAME ,
trunc(stream_element_date) lien_date ,
sty.STREAM_TYPE_PURPOSE ,
sty.name STREAM_TYPE,
trunc(ste.stream_element_date) stream_element_date,
ste.amount amount_imp ,
decode(date_billed,NULL,0,ste.amount) amount_billed,
decode(date_billed,NULL,0,ste.amount) amount
FROM okl_strm_elements ste,
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_b khr,
okl_k_headers khl,
okl_k_lines_full_v asset,
okc_line_styles_b ls,
okl_property_tax_v ptv,
okc_k_lines_b kle,
okc_statuses_b khs,
okc_statuses_b kls
WHERE ste.amount <> 0
AND stm.id = ste.stm_id
-- AND stm.active_yn = 'Y'
-- AND stm.say_code = 'CURR'
AND sty.id = stm.sty_id
AND sty.billable_yn = 'Y'
AND sty.STREAM_TYPE_PURPOSE = 'ACTUAL_PROPERTY_TAX'
AND khr.id = stm.khr_id
AND khr.scs_code IN ('LEASE', 'LOAN')
AND khr.id = cp_khr_id
AND asset.chr_id = khr.id
-- Add
AND asset.id = stm.kle_id
-- Add
AND asset.id = cp_kle_id
AND ls.id = asset.lse_id
AND ls.lty_code = 'FREE_FORM1'
AND ptv.id = ste.source_id
AND ste.source_table = 'OKL_PROPERTY_TAX_V'
AND khl.id = stm.khr_id
AND khl.deal_type IS NOT NULL
AND khs.code = khr.sts_code
-- AND khs.ste_code = 'ACTIVE'
AND kle.id(+) = stm.kle_id
AND kls.code(+) = kle.sts_code
AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED');
SELECT khr.contract_number,
asset.name,
sty.STREAM_TYPE_PURPOSE ,
sty.name STREAM_TYPE,
trunc(ste.stream_element_date) stream_element_date,
ste.amount amount
FROM okl_strm_elements ste,
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_all_b khr,
okl_k_lines_full_v asset,
okc_line_styles_b ls,
okl_k_headers khl,
okc_k_lines_b kle,
okc_statuses_b khs,
okc_statuses_b kls
WHERE ste.amount <> 0
AND stm.id = ste.stm_id
AND ste.date_billed IS NOT NULL
-- AND stm.active_yn = 'Y'
--AND stm.kle_id = cp_kle_id
-- AND stm.say_code = 'CURR'
AND sty.id = stm.sty_id
AND sty.billable_yn = 'Y'
AND sty.STREAM_TYPE_PURPOSE = 'ESTIMATED_PROPERTY_TAX'
AND khr.id = stm.khr_id
AND khr.scs_code IN ('LEASE', 'LOAN')
--AND khr.sts_code IN ( 'TERMINATED')
AND khr.id = cp_khr_id
AND asset.chr_id = khr.id
-- Add
AND asset.id = stm.kle_id
-- Add
AND asset.id = cp_kle_id
AND ls.id = asset.lse_id
AND ls.lty_code = 'FREE_FORM1'
AND khl.id = stm.khr_id
AND khl.deal_type IS NOT NULL
AND khs.code = khr.sts_code
-- AND khs.ste_code = 'ACTIVE'
AND kle.id (+) = stm.kle_id
AND kls.code (+) = kle.sts_code
AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
UNION
SELECT khr.contract_number,
asset.name,
sty.STREAM_TYPE_PURPOSE ,
sty.name STREAM_TYPE,
tai.date_invoiced,
til.amount amount
FROM okc_k_headers_all_b khr,
okl_trx_ar_invoices_b tai,
okl_txl_ar_inv_lns_b til,
okl_strm_type_v sty,
okl_k_lines_full_v asset,
okc_line_styles_b ls
WHERE khr.id = cp_khr_id
AND asset.chr_id = khr.id
AND asset.id = til.kle_id
AND ls.id = asset.lse_id
AND ls.lty_code = 'FREE_FORM1'
-- AND khr.sts_code IN ( 'TERMINATED')
AND tai.khr_id = khr.id
AND tai.id = til.tai_id
AND tai.qte_id IS NOT NULL
AND til.sty_id = sty.id
AND til.kle_id = cp_kle_id
AND sty.STREAM_TYPE_PURPOSE = 'AMPRTX';
SELECT khr.contract_number,
asset.name,
sty.STREAM_TYPE_PURPOSE ,
sty.name STREAM_TYPE,
trunc(ste.stream_element_date) stream_element_date,
ste.amount amount
FROM okl_strm_elements ste,
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_b khr,
okl_k_headers khl,
okl_k_lines_full_v asset,
okc_line_styles_b ls,
okc_k_lines_b kle,
okc_statuses_b khs,
okc_statuses_b kls
WHERE ste.amount <> 0
AND ste.date_billed IS NOT NULL
AND stm.id = ste.stm_id
AND stm.active_yn = 'Y'
-- AND stm.kle_id = cp_kle_id
AND stm.say_code = 'CURR'
AND sty.id = stm.sty_id
AND sty.billable_yn = 'Y'
AND sty.STREAM_TYPE_PURPOSE = 'ADJUSTED_PROPERTY_TAX'
AND khr.id = stm.khr_id
AND khr.scs_code IN ('LEASE', 'LOAN')
-- AND khr.sts_code IN ( 'TERMINATED')
AND khr.id = cp_khr_id
AND asset.chr_id = khr.id
-- Add
AND asset.id = stm.kle_id
-- Add
AND asset.id = cp_kle_id
AND ls.id = asset.lse_id
AND ls.lty_code = 'FREE_FORM1'
AND khl.id = stm.khr_id
AND khl.deal_type IS NOT NULL
AND khs.code = khr.sts_code
AND khs.ste_code = 'ACTIVE'
AND kle.id (+) = stm.kle_id
AND kls.code(+) = kle.sts_code
AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED');
SELECT name
FROM hr_operating_units
WHERE organization_id = mo_global.get_current_org_id() ;