[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT khr.id,
khr.contract_number,
khr.currency_code,
astb.id kle_id
FROM okc_k_headers_all_b khr,
okc_k_lines_b astb,
okc_k_lines_tl astl
WHERE astb.sts_code = 'TERMINATED'
AND khr.contract_number = nvl(p_contract_number, khr.contract_number)
AND astl.name = nvl(p_asset_number, astl.name)
AND astb.dnz_chr_id = khr.id
AND astb.id = astl.id
AND astl.LANGUAGE = userenv('LANG')
AND NOT EXISTS
(SELECT khr_id
FROM okl_trx_contracts trx
WHERE trx.khr_id = khr.id
AND(source_trx_id IS NULL OR source_trx_id = astb.id)
AND trx.tcn_type = 'EPT'
AND trx.tsu_code = 'PROCESSED'
--rkuttiya added for 12.1.1 Muti GAAP
AND trx.representation_type = 'PRIMARY');
SELECT *
FROM okl_k_lines_full_v
WHERE DNZ_CHR_ID = p_khr_id
AND id = p_kle_id;
SELECT NVL(SUM(ste.amount),0) amount
FROM okl_strm_elements ste,
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_b khr,
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 stm.kle_id = p_kle_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 = p_khr_id
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');
SELECT SUM(AMOUNT)
FROM (
SELECT NVL(SUM(ste.amount),0) amount
FROM okl_strm_elements ste,
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_b khr,
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.kle_id = p_kle_id
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 = p_khr_id
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 NVL(SUM(til.amount),0) amount
FROM okc_k_headers_b khr,
okl_trx_ar_invoices_v tai,
okl_txl_ar_inv_lns_v til,
okl_strm_type_v sty
WHERE khr.id = p_khr_id
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 = p_kle_id
AND sty.STREAM_TYPE_PURPOSE = 'AMPRTX');
SELECT id
FROM OKL_TRX_TYPES_V
WHERE NAME = 'Estimated Property Tax';
SELECT count(*)
FROM okl_streams stm,
okl_strm_type_v sty
WHERE stm.khr_id = p_khr_id
AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
AND stm.sty_id = sty.id
AND stm.say_code = 'CURR'
AND stm.active_yn = 'Y'
AND sty.stream_type_purpose = p_sty_name;
SELECT okl_sif_seq.nextval
FROM dual;
SELECT id
FROM okl_strm_type_v
WHERE STREAM_TYPE_PURPOSE = 'ADJUSTED_PROPERTY_TAX';
SELECT stm.id
FROM okl_streams stm,
okl_strm_type_v sty
WHERE stm.khr_id = p_khr_id
AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
AND stm.sty_id = sty.id
AND stm.say_code = 'CURR'
AND stm.active_yn = 'Y'
AND sty.STREAM_TYPE_PURPOSE = p_sty_name;
SELECT max(se_line_number)
FROM okl_strm_elements
WHERE stm_id = p_stm_id;
SELECT NAME
FROM hr_operating_units
WHERE ORGANIZATION_ID=MO_GLOBAL.GET_CURRENT_ORG_ID; -- MOAC fix - Bug#5378114 --varangan- 29-9-06
SELECT
RPAD(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),25,' ')
FROM DUAL;
SELECT rul.RULE_INFORMATION3
FROM okc_rule_groups_b rgp,
okc_rules_b rul
WHERE rgp.id = rul.rgp_id
AND rgp.rgd_code = 'LAASTX'
AND rul.RULE_INFORMATION_CATEGORY = 'LAPRTX'
AND rul.rule_information3 is not null
AND rgp.dnz_chr_id = p_chr_id
AND rgp.cle_id = p_cle_id;
Okl_Sel_Pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_selv_rec,
x_selv_rec);
-- Update Contract transaction status to be Success or error
------------------------------------------------------------
IF l_error_status = 'S' THEN
-- If there was no adjustment amounts to process
-- mark the record as ERROR to indicate nothing was processed.
-- This allows for future runs when actual property tax info
-- is uploaded at a later date
IF ( (l_actual_tax_amt = 0)
AND (l_estimated_tax_amt = 0)
AND (l_adjusted_amt = 0)
)
THEN
UPDATE OKL_TRX_CONTRACTS
SET TSU_CODE = 'ERROR'
WHERE ID = l_trxH_out_rec.ID;
UPDATE OKL_TRX_CONTRACTS
SET TSU_CODE = 'PROCESSED'
WHERE ID = l_trxH_out_rec.ID;
UPDATE OKL_TRX_CONTRACTS
SET TSU_CODE = 'ERROR'
WHERE ID = l_trxH_out_rec.ID;