[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE MESSAGE_NAME = p_message_name
AND LANGUAGE_CODE = USERENV('LANG');
select * from okl_fees_v ofv
WHERE ofv.parent_object_id=p_parent_object_id
AND ofv.fee_type=p_fee_type;
SELECT CFL.*
FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF,
OKL_CASH_FLOW_LEVELS CFL
WHERE CFO.ID=CAF.CFO_ID
AND CAF.ID=CFL.CAF_ID
AND CFO.oty_code=p_oty_code
AND CFO.source_id=p_source_id;
SELECT t1.* FROM OKL_QUICK_QUOTES_B t1
WHERE t1.id = p_quote_id;
SELECT t1.* FROM OKL_LEASE_QUOTES_B t1
WHERE t1.id = p_quote_id;
SELECT *
FROM OKL_LEASE_QUOTES_B
where id=p_lease_quote_id;
select lop.id,
lop.reference_number,
lop.prospect_id,
lop.prospect_address_id,
lop.cust_acct_id,
OKL_LEASE_APP_PVT.get_credit_classfication(
lop.prospect_id,
lop.cust_acct_id,
NULL) as customer_credit_class,
lop.sales_rep_id,
lop.sales_territory_id
from okl_lease_opportunities_b lop
where lop.id=p_parent_object_id;
select lapp.id,
lapp.reference_number,
lapp.prospect_id,
lapp.prospect_address_id,
lapp.cust_acct_id,
OKL_LEASE_APP_PVT.get_credit_classfication(
lapp.prospect_id,
lapp.cust_acct_id,
NULL) as customer_credit_class,
lapp.sales_rep_id,
lapp.sales_territory_id
from okl_lease_applications_b lapp
where lapp.id=p_parent_object_id;
select SUM(OEC)
FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
where OAB.PARENT_OBJECT_ID = OLQ.ID
AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
AND OLQ.ID= p_parent_object_id;
SELECT SUM(VALUE)
FROM OKL_COST_ADJUSTMENTS_B OCA,
OKL_ASSETS_B OAB
where OAB.PARENT_OBJECT_CODE = 'LEASEQUOTE'
AND OCA.PARENT_OBJECT_CODE='ASSET'
AND OCA.PARENT_OBJECT_ID=OAB.ID
and ADJUSTMENT_SOURCE_TYPE =p_adj_type
AND OAB.PARENT_OBJECT_ID = p_quote_id;
select OAC.INV_ITEM_ID
from OKL_ASSET_COMPONENTS_B OAC,
OKL_ASSETS_B OAB
WHERE OAC.ASSET_ID = OAB.ID
AND OAB.PARENT_OBJECT_CODE = 'LEASEQUOTE'
AND PRIMARY_COMPONENT='YES'
AND OAB.PARENT_OBJECT_ID = p_quote_id;
select srt.template_name as name,
srv.std_rate_tmpl_ver_id,
srv.version_number,
srv.effective_from_date effective_from,
srv.effective_to_date effective_to,
srv.srt_rate,
srv.sts_code,
srv.day_convention_code,
srv.spread spread,
srv.adj_mat_version_id adj_mat_version_id,
srv.min_adj_rate,
srv.max_adj_rate
from
okl_fe_std_rt_tmp_vers srv,
okl_fe_std_rt_tmp_v srt
where
srv.std_rate_tmpl_ver_id= p_srt_version_id
AND srt.std_rate_tmpl_id=srv.std_rate_tmpl_id;
SELECT source
FROM okl_data_src_fnctns_v
WHERE name = cp_function_name
AND fnctn_code = 'VALIDATION';
l_evaluated_string := 'SELECT '||l_evaluated_string ||' FROM dual';
select validation_set_id
FROM OKL_SYSTEM_PARAMS_ALL;
OKL_VLR_PVT.insert_row( p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_vlrv_tbl => lp_vlrv_tbl,
x_vlrv_tbl => lx_vlrv_tbl);
SELECT CFO.ID CFO_ID,
CAF.ID CAF_ID,
CAF.STY_ID,
CAF.cft_code,
CAF.due_arrears_yn
FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF
WHERE CAF.cfo_id = CFO.ID
AND CFO.OTY_CODE = p_oty_code
AND CFO.SOURCE_ID = p_quote_id;
SELECT CFL.id,
CFL.amount,
CFL.number_of_periods,
CFL.stub_days,
CFL.stub_amount
FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF,
OKL_CASH_FLOW_LEVELS CFL
WHERE CFO.ID=CAF.CFO_ID
AND CAF.ID=CFL.CAF_ID
AND CFO.oty_code=p_oty_code
AND CFO.source_id=p_source_id;
SELECT count(*) overriden_assets_count
FROM OKL_LEASE_QUOTES_B QTE,
OKL_ASSETS_B AST
WHERE AST.PARENT_OBJECT_ID = QTE.ID
AND ( AST.RATE_TEMPLATE_ID IS NOT NULL
OR AST.STRUCTURED_PRICING = 'Y' )
AND QTE.ID = p_quote_id
AND p_line_level_pricing = 'Y';
SELECT count(*) overriden_assets_count
FROM OKL_LEASE_QUOTES_B QTE,
OKL_ASSETS_B AST
WHERE AST.PARENT_OBJECT_ID = QTE.ID
AND ( AST.RATE_CARD_ID IS NOT NULL
OR AST.LEASE_RATE_FACTOR IS NOT NULL )
AND QTE.ID = p_quote_id
AND p_line_level_pricing = 'Y';
SELECT count(*) overriden_assets_count
FROM OKL_LEASE_QUOTES_B QTE,
OKL_ASSETS_B AST
WHERE AST.PARENT_OBJECT_ID = QTE.ID
AND ( AST.STRUCTURED_PRICING = 'Y')
AND QTE.ID = p_quote_id
AND p_line_level_pricing = 'Y';
SELECT count(*) assets_count
FROM OKL_LEASE_QUOTES_B QTE,
OKL_ASSETS_B AST
WHERE AST.PARENT_OBJECT_ID = QTE.ID
AND QTE.ID = p_quote_id;
SELECT OCA.id,OCA.adjustment_source_id
FROM OKL_COST_ADJUSTMENTS_B OCA,OKL_ASSETS_B OAB
WHERE OCA.PARENT_OBJECT_CODE = 'ASSET'
AND OCA.PARENT_OBJECT_ID = OAB.ID
AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
AND OAB.PARENT_OBJECT_ID = p_quote_id
AND OCA.ADJUSTMENT_SOURCE_TYPE= p_adj_source_type;
select validation_set_id
FROM OKL_SYSTEM_PARAMS;
SELECT VLD.failure_severity,FUNCTNS.NAME,FUNCTNS.SOURCE
FROM OKL_VALIDATIONS_B VLD,OKL_DATA_SRC_FNCTNS_B FUNCTNS
WHERE FUNCTNS.ID=VLD.FUNCTION_ID
AND VLD.VALIDATION_SET_ID =p_vls_id;
select oec_percentage
from OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
WHERE OLQ.PRICING_METHOD= 'SF'
AND OAB.parent_object_code='LEASEQUOTE'
AND OAB.parent_object_id = OLQ.id
AND OLQ.id= p_lease_quote_id;
select oac.unit_cost
from okl_assets_b oab,
okl_asset_components_b oac
where oab.parent_object_code='LEASEQUOTE'
AND oab.id=oac.asset_id
AND oac.primary_component='YES'
AND oab.parent_object_id=p_lease_quote_id;
select t2.* from OKL_QUICK_QUOTES_B t1,OKL_QUICK_QUOTE_LINES_B t2
WHERE t1.PRICING_METHOD=p_pricing_method
AND t2.type=p_type
AND t1.id=p_quick_quote_id
AND t2.quick_quote_id=t1.id;
select ITEM_CATEGORY_ID
FROM OKL_QUICK_QUOTE_LINES_B
WHERE type='ITEM_CATEGORY'
AND quick_quote_id=p_quick_quote_id;
select t2.value
from OKL_QUICK_QUOTE_LINES_B t2
WHERE t2.type = p_payment_type
and t2.QUICK_QUOTE_ID = p_quick_quote_id;
SELECT t1.* FROM OKL_QUICK_QUOTES_B t1
WHERE t1.id = p_quote_id;
select ITEM_CATEGORY_ID
FROM OKL_QUICK_QUOTE_LINES_B
WHERE type='ITEM_CATEGORY'
AND quick_quote_id=p_quick_quote_id;
select ofv.id,
ofv.rate_card_id,
ofv.rate_template_id,
'QUOTED_FEES' oty_code
from okl_fees_b ofv
where ofv.parent_object_code='LEASEQUOTE'
AND ofv.parent_object_id=p_quote_id
AND ofv.fee_type IN ('FINANCED','ROLLOVER')
UNION
select oab.id,
oab.rate_card_id,
oab.rate_template_id,
'QUOTED_ASSET' oty_code
from okl_assets_b oab
where oab.parent_object_code='LEASEQUOTE'
AND oab.parent_object_id=p_quote_id;
select lrs.name
from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv
where lrs.id=lrv.rate_set_id
and lrv.rate_set_version_id = p_srt_ver_id;
select srt.template_name as name
from
okl_fe_std_rt_tmp_v srt,
okl_fe_std_rt_tmp_vers srv
where srt.std_rate_tmpl_id=srv.std_rate_tmpl_id
AND srv.std_rate_tmpl_ver_id = p_srt_ver_id;
SELECT t1.* FROM OKL_QUICK_QUOTES_B t1
WHERE t1.id = p_quick_quote_id;
SELECT SUM(NVL(VALUE,0))
FROM OKL_QUICK_QUOTE_LINES_B
WHERE type='ITEM_CATEGORY'
AND quick_quote_id=p_quick_quote_id;
select SUM(NVL(VALUE,0))
from OKL_QUICK_QUOTE_LINES_B t2
WHERE t2.type IN('DOWN_PAYMENT','TRADEIN','SUBSIDY')
and t2.basis = 'FIXED'
and t2.QUICK_QUOTE_ID=p_quick_quote_id;
select SUM(NVL(VALUE,0))
from OKL_QUICK_QUOTE_LINES_B t2
WHERE t2.type IN('DOWN_PAYMENT','TRADEIN','SUBSIDY')
and t2.basis = 'ASSET_COST'
and t2.QUICK_QUOTE_ID=p_quick_quote_id;
SELECT SUM(NVL(VALUE,0)) FROM OKL_COST_ADJUSTMENTS_B
where PARENT_OBJECT_CODE='ASSET'
and ADJUSTMENT_SOURCE_TYPE IN('DOWN_PAYMENT','TRADEIN','SUBSIDY')
AND PARENT_OBJECT_ID=p_asset_id;
SELECT t2.id,t2.oec
FROM OKL_ASSETS_B t2
where t2.parent_object_code='LEASEQUOTE'
and t2.parent_object_id=p_quote_id;
SELECT * from okl_assets_b
where PARENT_OBJECT_CODE='LEASEQUOTE'
AND PARENT_OBJECT_ID=p_quote_id;
select t2.*
from OKL_QUICK_QUOTE_LINES_b t2
WHERE t2.quick_quote_id=p_quote_id
AND t2.type='ITEM_CATEGORY';
SELECT 'x'
FROM OKL_PRODUCTS PDT,
OKL_AE_TMPT_SETS AES,
OKL_ST_GEN_TMPT_SETS GTS,
OKL_ST_GEN_TEMPLATES GTT,
OKL_FE_EO_TERMS_V ETO,
OKL_FE_EO_TERM_VERS ETV
WHERE ETV.END_OF_TERM_VER_ID=p_eotv_id
AND ETV.END_OF_TERM_ID = ETO.END_OF_TERM_ID
AND PDT.ID = ETO.PRODUCT_ID
AND PDT.AES_ID = AES.ID
AND AES.GTS_ID = GTS.ID
AND GTT.GTS_ID = GTS.ID
AND GTT.START_DATE <= P_START_DATE
AND NVL(GTT.END_DATE, P_START_DATE) >= P_START_DATE
AND PDT.PRODUCT_STATUS_CODE = 'APPROVED'
AND GTT.TMPT_STATUS = 'ACTIVE';
SELECT 'x'
FROM OKL_PRODUCTS PDT,
OKL_AE_TMPT_SETS AES,
OKL_ST_GEN_TMPT_SETS GTS,
OKL_ST_GEN_TEMPLATES GTT
WHERE PDT.ID = pdt_id
AND PDT.AES_ID = AES.ID
AND AES.GTS_ID = GTS.ID
AND GTT.GTS_ID = GTS.ID
AND GTT.START_DATE <= p_start_date
AND nvl(GTT.END_DATE, p_start_date) >= p_start_date
AND PDT.PRODUCT_STATUS_CODE = 'APPROVED'
AND GTT.TMPT_STATUS = 'ACTIVE';
SELECT NVL(tax_upfront_yn,'N')
FROM OKL_SYSTEM_PARAMS;
--Check whether the Product Id selected on Quote is having
--Active Stream Generation template's effective start dates between the
--Quote Expected Start dates
OPEN c_lq_header_rec(lp_quote_id);
--Check whether the Product Id associated with EOT selected on Quote is having
--Active Stream Generation template having effective start dates between the
--Quote Expected Start dates
OPEN c_qq_header_rec(lp_quote_id);
select t2.* from OKL_QUICK_QUOTES_B t1,OKL_QUICK_QUOTE_LINES_B t2
WHERE t1.PRICING_METHOD='SF'
AND t2.type='SUBSIDY'
AND t1.id=p_quick_quote_id
AND t2.quick_quote_id=t1.id;
SELECT t2.*
FROM OKL_LEASE_QUOTES_B t1,OKL_ASSETS_B t2
where t1.id=p_quote_id
AND t1.pricing_method='SF'
and t2.parent_object_code='LEASEQUOTE'
and t2.parent_object_id=t1.id;
SELECT BASIS FROM OKL_COST_ADJUSTMENTS_B
where PARENT_OBJECT_CODE='ASSET'
and ADJUSTMENT_SOURCE_TYPE='SUBSIDY'
AND PARENT_OBJECT_ID=p_asset_id;
SELECT ID,END_OF_TERM_VALUE_DEFAULT,END_OF_TERM_VALUE
FROM OKL_ASSETS_B OLA
WHERE OLA.PARENT_OBJECT_ID=p_quote_id
AND OLA.PARENT_OBJECT_CODE='LEASEQUOTE';
SELECT 'x'
FROM OKL_QUICK_QUOTE_LINES_B OAL
WHERE OAL.QUICK_QUOTE_ID=p_quote_id
AND OAL.TYPE='ITEM_CATEGORY';
select ofv.*
from okl_fees_v ofv
where ofv.parent_object_code='LEASEQUOTE'
AND ofv.parent_object_id=p_quote_id
AND ofv.fee_type IN ('FINANCED','ROLLOVER');
select olr.*
from okl_line_relationships_b olr,
okl_fees_b ofv
where ofv.FEE_TYPE='CAPITALIZED'
AND olr.related_line_id = p_fee_id
AND olr.related_line_id = ofv.id -- Added by rravikir for Bug 4736523
AND olr.related_line_type = 'CAPITALIZED';
select ofv.id,
ofv.rate_card_id,
ofv.rate_template_id,
ofv.structured_pricing,
ofv.lease_rate_factor,
'QUOTED_FEE' oty_code,
ofv.target_arrears,
ofv.target_amount,
STYT.NAME NAME
from okl_fees_b ofv,
OKL_STRM_TYPE_B STY,
OKL_STRM_TYPE_TL STYT
where ofv.parent_object_code='LEASEQUOTE'
AND ofv.parent_object_id=p_quote_id
AND ofv.fee_type IN ('FINANCED','ROLLOVER')
AND ofv.STREAM_TYPE_ID = STY.ID
AND STY.ID = STYT.ID
AND STYT.LANGUAGE = USERENV('LANG');
select oab.id,
oab.rate_card_id,
oab.rate_template_id,
oab.structured_pricing,
oab.lease_rate_factor,
'QUOTED_ASSET' oty_code,
oab.target_arrears,
oab.target_amount
from okl_assets_b oab
where oab.parent_object_code='LEASEQUOTE'
AND oab.parent_object_id=p_quote_id;
select ofv.id,
ofv.rate_card_id,
ofv.rate_template_id,
ofv.structured_pricing,
ofv.lease_rate_factor,
'QUOTED_FEE' oty_code
from okl_fees_b ofv
where ofv.parent_object_code='LEASEQUOTE'
AND ofv.parent_object_id=p_quote_id
AND ofv.fee_type IN ('FINANCED','ROLLOVER')
UNION
select oab.id,
oab.rate_card_id,
oab.rate_template_id,
oab.structured_pricing,
oab.lease_rate_factor,
'QUOTED_ASSET' oty_code
from okl_assets_b oab
where oab.parent_object_code='LEASEQUOTE'
AND oab.parent_object_id=p_quote_id;
SELECT TRUNC(CFL.start_date)
FROM OKL_CASH_FLOWS CAF,OKL_CASH_FLOW_LEVELS CFL
WHERE CAF.ID=CFL.CAF_ID
AND CAF.dnz_qte_id=p_quote_id;
select 'x'
from okc_k_headers_v tbl
where tbl.id=p_vp_id
AND p_contract_start_date between tbl.start_date and NVL(tbl.end_date,p_contract_start_date)
AND tbl.SCS_CODE='PROGRAM'
AND tbl.STS_CODE='ACTIVE'
AND tbl.template_yn='N';
SELECT 'Y'
FROM okl_fe_rate_set_versions
WHERE rate_set_version_id = p_lrs_version_id
AND effective_from_date <= p_exp_start_date
AND nvl(effective_to_date,p_exp_start_date) >= p_exp_start_date;
SELECT 'Y'
FROM okl_fe_std_rt_tmp_vers
WHERE std_rate_tmpl_ver_id = p_srt_version_id
AND effective_from_date <= p_exp_start_date
AND nvl(effective_to_date,p_exp_start_date) >= p_exp_start_date;
SELECT count(*) cfl_count
FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF,
OKL_CASH_FLOW_LEVELS CFL
WHERE CFO.ID=CAF.CFO_ID
AND CAF.ID=CFL.CAF_ID
AND CFO.oty_code=p_oty_code
AND CFO.source_id=p_source_id;
select TRUNC(EXPECTED_START_DATE) INTO lp_cont_start_date
from OKL_LEASE_QUOTES_B
WHERE ID=lp_quote_id;
SELECT count(1) INTO l_cnt
from OKL_QUICK_QUOTES_B
WHERE ID=lp_quote_id
AND PRICING_METHOD IN('SF','SS','SY');
SELECT TRUNC(EXPECTED_START_DATE) INTO lp_cont_start_date
FROM OKL_QUICK_QUOTES_B
WHERE ID=lp_quote_id;
select TRUNC(EXPECTED_START_DATE),PROGRAM_AGREEMENT_ID INTO lp_cont_start_date,lp_vp_id
from OKL_QUICK_QUOTES_B
WHERE ID=lp_quote_id;
SELECT NVL(tax_upfront_yn,'N')
FROM OKL_SYSTEM_PARAMS;
SELECT OLQ.ID
FROM OKL_LEASE_QUOTES_B OLQ
WHERE PARENT_OBJECT_ID=p_parent_object_id
AND PARENT_OBJECT_CODE=p_object_type
AND PRIMARY_QUOTE='Y';
DELETE OKL_VALIDATION_RESULTS_TL
WHERE ID IN (SELECT ID
FROM OKL_VALIDATION_RESULTS_B
WHERE PARENT_OBJECT_CODE = lp_object_type
AND PARENT_OBJECT_ID = lp_quote_id);
DELETE OKL_VALIDATION_RESULTS_B
WHERE PARENT_OBJECT_CODE = lp_object_type
AND PARENT_OBJECT_ID = lp_quote_id;
SELECT OLQ.ID
FROM OKL_LEASE_QUOTES_B OLQ
WHERE PARENT_OBJECT_ID=p_parent_object_id
AND PARENT_OBJECT_CODE=p_object_type
AND PRIMARY_QUOTE='Y';