[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKL_K_HEADERS
WHERE ID = p_khr_id ;
SELECT asset_id, original_cost, asset_number, corporate_book
FROM okx_asset_lines_v ast
WHERE ast.dnz_chr_id = p_khr_id;
SELECT MAX(dpr.deprn_reserve)
FROM OKX_AST_DPRTNS_V dpr
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code;
SELECT SUM(NVL(AMOUNT,0)) tot_res_amt
FROM OKL_TRX_CONTRACTS
WHERE KHR_ID = p_khr_id
AND tcn_type = 'PSP'
--Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
AND tsu_code = 'PROCESSED'
-- SGIYER.MGAAP Changes for Bug 7263041
AND representation_type = 'PRIMARY';
SELECT contract_number
FROM OKC_K_HEADERS_B
WHERE id = p_cntrct_id;
SELECT SUM(ste.amount)
FROM OKL_STRM_TYPE_B sty,
OKL_STREAMS stm,
OKL_STRM_ELEMENTS ste
WHERE stm.khr_id = p_ctr_id
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR'
AND sty.id = p_prin_bal_id
AND stm.sty_id = sty.id
AND ste.stm_id = stm.id
AND ste.stream_element_date BETWEEN p_start_date AND p_end_date;
SELECT SUM(ste.amount)
FROM OKL_STRM_TYPE_B sty,
OKL_STREAMS stm,
OKL_STRM_ELEMENTS ste
WHERE stm.khr_id = p_ctr_id
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR'
AND sty.id = p_prin_bal_id
AND stm.sty_id = sty.id
AND ste.stm_id = stm.id
AND ste.stream_element_date = (SELECT MAX(stream_element_date)
FROM OKL_STRM_TYPE_B sty,
OKL_STREAMS stm,
OKL_STRM_ELEMENTS ste
WHERE stm.khr_id = p_ctr_id
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR'
AND sty.id = p_prin_bal_id
AND stm.sty_id = sty.id
AND ste.stm_id = stm.id
AND stream_element_date < p_start_date);
SELECT currency_code
FROM OKC_K_HEADERS_B
WHERE id = p_khr_id;
SELECT pdt.quality_val revenue_recognition_method
FROM OKL_PROD_QLTY_VAL_UV pdt,
OKL_K_HEADERS_FULL_V khr
WHERE khr.id = p_chr_id
AND khr.pdt_id = pdt.pdt_id
AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD';
SELECT TRUNC(DATE_LAST_INTERIM_INTEREST_CAL)
FROM OKL_K_HEADERS
WHERE ID = p_cntrct_id;
SELECT con.object1_id1
FROM OKC_K_HEADERS_B CHR,
OKC_CONTACT_SOURCES cso,
OKC_K_PARTY_ROLES_B kpr,
OKC_CONTACTS con
WHERE CHR.id = cp_chr_id
AND cso.cro_code = 'SALESPERSON'
AND cso.rle_code = 'LESSOR'
AND cso.buy_or_sell = CHR.buy_or_sell
AND kpr.chr_id = CHR.id
AND kpr.dnz_chr_id = CHR.id
AND kpr.rle_code = cso.rle_code
AND con.cpl_id = kpr.id
AND con.dnz_chr_id = CHR.id
AND con.cro_code = cso.cro_code
AND con.jtot_object1_code = cso.jtot_object_code;
SELECT mo_global.get_current_org_id()
FROM dual;
SELECT ctt.cust_trx_type_id
FROM ra_cust_trx_types ctt
WHERE ctt.name = 'Invoice-OKL';
SELECT bill_to_site_use_id
FROM OKC_K_HEADERS_B
WHERE id = p_chr_id;
-- 29-MAY-02 sgiyer added where clause to select only active contracts
-- 13-DEC-02 sgiyer added where clause to select lease contracts only
-- changed where clause for performance
-- and added multi-currency columns in select criteria
-- bug 3448020. removing under revision status
CURSOR okl_pdt_cntrcts_csr (p_pdt_id OKL_TRX_CONTRACTS.PDT_ID%TYPE) IS
SELECT chr.id
,chr.contract_number
,khr.deal_type
,chr.currency_code
,khr.currency_conversion_type
,khr.currency_conversion_rate
,khr.currency_conversion_date
-- get the last interest calc date .. racheruv. Bug 6342556
,TRUNC(nvl(khr.date_last_interim_interest_cal, chr.start_date)) last_int_calc_date
FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
WHERE khr.pdt_id = p_pdt_id
AND chr.id = khr.id
AND sts_code IN ('BOOKED','EVERGREEN')
AND chr.scs_code = 'LEASE';
SELECT chr.id
,chr.contract_number
,khr.deal_type
,chr.currency_code
,khr.currency_conversion_type
,khr.currency_conversion_rate
,khr.currency_conversion_date
FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
WHERE khr.pdt_id = p_pdt_id
AND chr.id = khr.id
AND sts_code = 'ACTIVE'
AND chr.scs_code = 'INVESTOR';
SELECT okx.aging_bucket_line_id, bkt.id bkt_id, okx.bucket_name, okx.days_start, okx.days_to, bkt.loss_rate
FROM OKX_AGING_BUCKETS_V okx, OKL_BUCKETS_V bkt
WHERE okx.aging_bucket_id = l_bucket_id
AND okx.aging_bucket_line_id = bkt.ibc_id
AND bkt.end_date IS NULL
ORDER by okx.bucket_sequence_num;
SELECT id
FROM OKL_TRX_TYPES_TL
WHERE NAME = l_try_name
AND LANGUAGE = 'US';
SELECT loss_rate
FROM OKL_BUCKETS_V
WHERE IBC_ID = p_aging_bucket_line_id
AND end_date IS NULL;
SELECT pdt.name name, pqy.name product_subclass
FROM okl_products pdt,
okl_pdt_pqy_vals pqv,
okl_pdt_qualitys pqy,
okl_pqy_values qve
WHERE pdt.id = pqv.pdt_id
AND pqv.qve_id = qve.id
AND qve.pqy_id = pqy.id
AND pqy.name IN ('LEASE','INVESTOR')
AND pdt.id = l_product_id;
SELECT PRECISION
FROM fnd_currencies_vl
WHERE currency_code = p_curr_code
AND enabled_flag = 'Y'
AND NVL(start_date_active, l_sysdate) <= l_sysdate
AND NVL(end_date_active, l_sysdate) >= l_sysdate;
-- Cursor to select currency conversion information
-- CURSOR currency_conv_csr(p_conversion_type VARCHAR2, p_from_currency VARCHAR2, p_to_currency VARCHAR2, p_conversion_date DATE) IS
-- SELECT conversion_rate
-- FROM GL_DAILY_RATES
-- WHERE conversion_type = p_conversion_type
-- AND conversion_date = p_conversion_date
-- AND from_currency = p_from_currency
-- AND to_currency = p_to_currency
-- AND status_code = 'C';
SELECT 'Y'
FROM OKL_TRX_CONTRACTS
WHERE khr_id = p_khr_id
AND tcn_type = 'PSP'
AND tsu_code = l_tsu_code
AND representation_type = 'PRIMARY'; -- SGIYER MGAAP Changes Bug 7263041
SELECT 'Y'
FROM OKL_TRX_CONTRACTS
WHERE khr_id = p_khr_id
AND tcn_type = 'PGL'
AND tsu_code = l_tsu_code
AND representation_type = 'PRIMARY'; -- SGIYER MGAAP Changes Bug 7263041
SELECT amount_due_remaining, due_date
FROM okl_bpd_contract_invoices_v
WHERE contract_id = p_khr_id
AND status = 'OP'
AND amount_due_remaining > 0
AND revenue_rec_basis <> 'CASH_RECEIPT'
AND due_date <= p_entry_date;
-- Cursor to select lease contracts within a pool for an investor agreement.
CURSOR pool_contents_csr (p_agr_id NUMBER) IS
SELECT chr.id chr_id,
sty.id sty_id,
sty.stream_type_subclass sty_subclass,
poc.streams_to_date streams_to_date
FROM OKL_POOLS pol,
OKL_POOL_CONTENTS poc,
OKL_STRM_TYPE_B sty,
OKC_K_HEADERS_B chr,
OKL_K_HEADERS khr
WHERE pol.khr_id = p_agr_id
AND pol.id = poc.pol_id
AND poc.status_code = 'ACTIVE'
AND poc.sty_id = sty.id
--Bug 6740000 ssdeshpa Impact for Loan Contracts added into the pool start
AND sty.stream_type_subclass IN ('RENT', 'RESIDUAL', 'LOAN_PAYMENT')
--Bug 6740000 ssdeshpa End
AND poc.khr_id = chr.id
AND chr.id = khr.id;
-- cursor to select open items for a contract
-- Bug 4058948. Changing view from okl_bpd_leasing_payment_trx_v to okl_bpd_contract_invoices_v.
-- Also adding new where condition to exclude invoices subject to cash receipt.
CURSOR open_items_csr (p_khr_id NUMBER, p_sty_id NUMBER) IS
SELECT amount_due_remaining, due_date
FROM okl_bpd_contract_invoices_v
WHERE contract_id = p_khr_id
AND status = 'OP'
AND amount_due_remaining > 0
AND revenue_rec_basis <> 'CASH_RECEIPT'
AND due_date <= l_entry_date
AND stream_type_id = p_sty_id;
-- cursor to select residual value amount
CURSOR residual_value_csr (p_khr_id NUMBER, p_sty_id NUMBER) IS
SELECT ste.amount
FROM OKL_STRM_TYPE_B sty,
OKL_STREAMS stm,
OKL_STRM_ELEMENTS ste
WHERE stm.khr_id = p_khr_id
AND stm.sty_id = sty.id
AND sty.id = p_sty_id
AND stm.id = ste.stm_id
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR';
SELECT name
FROM hr_operating_units
WHERE organization_id = p_org_id;
SELECT pdt.quality_val revenue_recognition_method
FROM OKL_PROD_QLTY_VAL_UV pdt,
OKL_K_HEADERS_FULL_V khr
WHERE khr.id = p_chr_id
AND khr.pdt_id = pdt.pdt_id
AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD';
SELECT id
FROM OKL_TRX_TYPES_TL
WHERE NAME = l_try_name
AND LANGUAGE = 'US';
SELECT scs_code
FROM OKL_K_HEADERS_FULL_V
WHERE id = p_slpv_rec.khr_id;
SELECT 'Y'
FROM OKL_TRX_CONTRACTS
WHERE khr_id = p_ctr_id
AND tcn_type = 'PGL'
AND tsu_code = l_tsu_code
AND representation_type='PRIMARY';
SELECT 'Y'
FROM OKL_TRX_CONTRACTS
WHERE khr_id = p_ctr_id
AND tcn_type = 'PSP'
AND tsu_code = l_tsu_code
AND representation_type='PRIMARY';
SELECT contract_number
FROM OKL_K_HEADERS_FULL_V
WHERE id = p_ctr_id;
SELECT pdt_id
FROM OKL_K_HEADERS_FULL_V
WHERE id = p_ctr_id;
SELECT chr.currency_code currency_code,
khr.currency_conversion_type currency_conversion_type,
khr.currency_conversion_date currency_conversion_date,
khr.currency_conversion_rate currency_conversion_rate
FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
WHERE chr.id = p_khr_id
AND chr.id = khr.id;