ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2143869E053B46B63588994Y SELECT khr.contract_number CONTRACT_NUMBER, asset.name ASSET_NUMBER, 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, decode(date_billed,NULL,0,ste.amount) - ste.amount DIFF_AMT1, 0 SUM_AMT1 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 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 = :CHR_ID AND asset.chr_id = khr.id AND asset.id = stm.kle_id AND asset.id = :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 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 CONTRACT_NUMBER, asset.name EST_PROP_ASST_NUM, NULL EST_PROP_JURSDCTN_NAME, NULL EST_PROP_LIEN_DATE, sty.STREAM_TYPE_PURPOSE EST_PROP_STRM_TYPE_PUR, sty.name EST_PROP_STRM_TYPE, trunc(ste.stream_element_date) EST_PROP_STRM_ELE_DATE, 0 EST_PROP_AMOUNT_IMP, 0 EST_PROP_AMOUNT_BILLED, ste.amount EST_PROP_AMOUNT, 0 DIFF_AMT1, ste.amount SUM_AMT1 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 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.id = :CHR_ID AND asset.chr_id = khr.id AND asset.id = stm.kle_id AND asset.id = :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 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, NULL EST_PROP_JURSDCTN_NAME, NULL EST_PROP_LIEN_DATE, sty.STREAM_TYPE_PURPOSE , sty.name STREAM_TYPE, tai.date_invoiced, 0 EST_PROP_AMOUNT_IMP, 0 EST_PROP_AMOUNT_BILLED, til.amount amount, 0 DIFF_AMT1, til.amount SUM_AMT1 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 = :CHR_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 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 = :KLE_ID AND sty.STREAM_TYPE_PURPOSE = 'AMPRTX' UNION SELECT khr.contract_number ADJ_PROP_CON_NUM, asset.name ADJ_PROP_ASST_NUM, NULL ADJ_PROP_JURSDCTN_NAME, NULL ADJ_PROP_LIEN_DATE, sty.STREAM_TYPE_PURPOSE ADJ_PROP_STRM_TYPE_PUR, sty.name ADJ_PROP_STRM_TYPE, trunc(ste.stream_element_date) ADJ_PROP_STRM_ELE_DATE, 0 ADJ_PROP_AMOUNT_IMP, 0 ADJ_PROP_AMOUNT_BILLED, ste.amount ADJ_PROP_TAX_AMOUNT, 0 DIFF_AMT1, 0 SUM_AMT1 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.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.id = :CHR_ID AND asset.chr_id = khr.id AND asset.id = stm.kle_id AND asset.id = :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') OKL OKLBPPTAXRPT AR OKL تقرير ضريبة الملكية في عقد الإيجار Application: إدارة الإيجار Source: تقرير ضريبة الملكية في عقد الإيجار Short Name: OKLBPPTAXRPT DB package: D OKL Leasing - Vermögensteuer Application: Lease and Finance Management Source: Leasing - Vermögensteuer Short Name: OKLBPPTAXRPT DB package: F OKL Crédit-bail - Etat des montants d'impôt foncier Application: Lease and Finance Management Source: Crédit-bail - Etat des montants d'impôt foncier Short Name: OKLBPPTAXRPT DB package: US OKL Lease Property Tax Application: Lease and Finance Management Source: Lease Property Tax Report Short Name: OKLBPPTAXRPT DB package: ZHS OKL 租赁财产税报表 Application: Oracle Lease and Finance Management Source: 租赁财产税报表 Short Name: OKLBPPTAXRPT DB package: BI Publisher :chr_id :kle_id :operating_unit 1 10 :p_cont_num_from LOV Oracle OKL_PROPERTY_TAX_KHR_NUM_FROM Y select chr.contract_number id, chr.contract_number value, chr.contract_number description from okc_k_headers_b chr,okl_k_headers khr where khr.id=chr.id and chr.scs_code='LEASE' order by contract_number AR رقم العقد من D Von Vertragsnummer F Numéro de contrat - De US Contract Number From ZHS 合同编号自 2 20 :p_cont_num_to LOV Oracle OKL_PROPERTY_TAX_KHR_NUM_TO Y select chr.contract_number id, chr.contract_number value, chr.contract_number description from okc_k_headers_b chr,okl_k_headers khr where khr.id=chr.id and chr.scs_code='LEASE' order by contract_number AR رقم العقد إلى D Bis Vertragsnummer F Numéro de contrat - A US Contract Number To ZHS 合同编号至 3 30 :p_asset_name_from LOV Oracle OKL_PROPERTY_TAX_ASSET_NAME Y select asset.name id, asset.name value, asset.name description from okc_k_headers_b chr,okl_k_lines_full_v asset,okc_line_styles_b ls where chr.contract_number between nvl(:$flex$.okl_property_tax_khr_num_from:null,chr.contract_number) and nvl(:$flex$.okl_property_tax_khr_num_to:null,chr.contract_number) and asset.chr_id=chr.id and ls.id=asset.lse_id and ls.lty_code='FREE_FORM1' and chr.scs_code='LEASE' order by asset.name AR رقم الأصل من D Von Anlagennummer F Numéro de bien - De US Asset Number From ZHS 资产编号自 4 40 :p_asset_name_to LOV Oracle OKL_PROPERTY_TAX_ASSET_NAME Y select asset.name id, asset.name value, asset.name description from okc_k_headers_b chr,okl_k_lines_full_v asset,okc_line_styles_b ls where chr.contract_number between nvl(:$flex$.okl_property_tax_khr_num_from:null,chr.contract_number) and nvl(:$flex$.okl_property_tax_khr_num_to:null,chr.contract_number) and asset.chr_id=chr.id and ls.id=asset.lse_id and ls.lty_code='FREE_FORM1' and chr.scs_code='LEASE' order by asset.name AR رقم الأصل إلى D Bis Anlagennummer F Numéro de bien - A US Asset Number To ZHS 资产编号至