[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT olav.ID,
olav.REFERENCE_NUMBER,
olav.PROSPECT_ID,
olav.PROSPECT_ADDRESS_ID,
olav.CUST_ACCT_ID,
olav.PROGRAM_AGREEMENT_ID,
olav.CURRENCY_CODE,
olav.CURRENCY_CONVERSION_TYPE,
olav.CURRENCY_CONVERSION_RATE,
olav.CURRENCY_CONVERSION_DATE,
olav.CREDIT_LINE_ID,
olav.MASTER_LEASE_ID,
olav.PARENT_LEASEAPP_ID,
olav.SALES_REP_ID,
olav.ORG_ID,
olav.INV_ORG_ID,
olqv.EXPECTED_START_DATE,
olqv.REFERENCE_NUMBER QUOTE_NUMBER,
olqv.TERM,
olqv.PRODUCT_ID,
olqv.PROPERTY_TAX_APPLICABLE,
olqv.PROPERTY_TAX_BILLING_TYPE,
olqv.UPFRONT_TAX_TREATMENT,
olqv.UPFRONT_TAX_STREAM_TYPE,
olqv.TRANSFER_OF_TITLE,
olqv.AGE_OF_EQUIPMENT,
olqv.PURCHASE_OF_LEASE,
olqv.SALE_AND_LEASE_BACK,
olqv.INTEREST_DISCLOSED,
olqv.ID QUOTE_ID,
olqv.EXPECTED_DELIVERY_DATE,
olqv.EXPECTED_FUNDING_DATE,
olqv.LEGAL_ENTITY_ID,
olqv.LINE_INTENDED_USE -- Bug 5908845. eBTax Enhancement Project
,olav.SHORT_DESCRIPTION -- ER# 9161779
FROM okl_lease_applications_v olav,
okl_lease_quotes_v olqv
WHERE olqv.PARENT_OBJECT_CODE = 'LEASEAPP'
AND olqv.PARENT_OBJECT_ID = olav.ID
AND olav.APPLICATION_STATUS = 'CR-APPROVED'
AND olqv.primary_quote = 'Y'
AND olav.ID = p_lap_id;
SELECT olov.ID,
olov.REFERENCE_NUMBER,
olov.PROSPECT_ID,
olov.PROSPECT_ADDRESS_ID,
olov.CUST_ACCT_ID,
olov.PROGRAM_AGREEMENT_ID,
olov.CURRENCY_CODE,
olov.CURRENCY_CONVERSION_TYPE,
olov.CURRENCY_CONVERSION_RATE,
olov.CURRENCY_CONVERSION_DATE,
NULL CREDIT_LINE_ID,
olov.MASTER_LEASE_ID,
NULL PARENT_LEASEAPP_ID,
olov.SALES_REP_ID,
olov.ORG_ID,
olov.INV_ORG_ID,
olqv.EXPECTED_START_DATE,
olqv.REFERENCE_NUMBER QUOTE_NUMBER,
olqv.TERM,
olqv.PRODUCT_ID,
olqv.PROPERTY_TAX_APPLICABLE,
olqv.PROPERTY_TAX_BILLING_TYPE,
olqv.UPFRONT_TAX_TREATMENT,
olqv.UPFRONT_TAX_STREAM_TYPE,
olqv.TRANSFER_OF_TITLE,
olqv.AGE_OF_EQUIPMENT,
olqv.PURCHASE_OF_LEASE,
olqv.SALE_AND_LEASE_BACK,
olqv.INTEREST_DISCLOSED,
olqv.ID QUOTE_ID,
olqv.EXPECTED_DELIVERY_DATE,
olqv.EXPECTED_FUNDING_DATE,
olqv.LEGAL_ENTITY_ID,
olqv.LINE_INTENDED_USE -- Bug 5908845. eBTax Enhancement Project
,olov.SHORT_DESCRIPTION -- ER# 9161779
FROM okl_lease_opportunities_v olov,
okl_lease_quotes_v olqv
WHERE olqv.PARENT_OBJECT_CODE = 'LEASEOPP'
AND olqv.PARENT_OBJECT_ID = olov.ID
AND olqv.status = 'CT-ACCEPTED'
AND olov.ID = p_lop_id;
SELECT LAB.REFERENCE_NUMBER LSE_APP
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
FROM OKL_LEASE_APPLICATIONS_B LAB
, OKL_LEASE_QUOTES_B QTE
, OKC_K_HEADERS_B CHR
, OKC_STATUSES_V CSTS
WHERE LAB.LEASE_OPPORTUNITY_ID = QTE.PARENT_OBJECT_ID
AND QTE.PARENT_OBJECT_CODE = 'LEASEOPP'
AND LAB.APPLICATION_STATUS = 'CONV-K'
AND LAB.ID = CHR.ORIG_SYSTEM_ID1
AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
AND CHR.STS_CODE = CSTS.CODE
AND CSTS.STE_CODE <> 'CANCELLED'
AND QTE.ID = p_qte_id;
SELECT LSQ.REFERENCE_NUMBER LSE_QTE
, LOP.REFERENCE_NUMBER LSE_OPP
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
FROM OKL_LEASE_QUOTES_B LSQ
, OKL_LEASE_OPPORTUNITIES_B LOP
, OKC_K_HEADERS_B CHR
, OKC_STATUSES_V CSTS
WHERE CHR.ORIG_SYSTEM_ID1 = LOP.ID
AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_QUOTE'
AND CSTS.CODE = CHR.STS_CODE
AND CSTS.STE_CODE <> 'CANCELLED'
AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'
AND LSQ.PARENT_OBJECT_ID = LOP.ID
AND LSQ.STATUS = 'CT-ACCEPTED'
AND LSQ.ID = p_quote_id;
PROCEDURE update_leaseapp_status(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
END update_leaseapp_status;
SELECT COUNT(1)
FROM okc_k_party_roles_v
WHERE dnz_chr_id = p_chr_id
AND chr_id = p_chr_id
AND rle_code = 'OKL_VENDOR'
AND JTOT_OBJECT1_CODE = 'OKX_VENDOR'
AND cle_id = p_cle_id
AND object1_id1 = p_vendor_id;
SELECT COUNT(1)
FROM okc_k_party_roles_v
WHERE dnz_chr_id = p_chr_id
AND chr_id = p_chr_id
AND rle_code = 'OKL_VENDOR'
AND JTOT_OBJECT1_CODE = 'OKX_VENDOR'
AND cle_id is null
AND object1_id1 = p_vendor_id;
SELECT object1_id1 frequency, object2_id1 laslh_id, fnd_date.canonical_to_date(rule_information2) start_date,
rule_information3 periods, rule_information6 amount,
rule_information5 payment_structure, rule_information13 rate,
rule_information7 stub_days, rule_information8 stub_amount, rule_information10 arrears
FROM okc_rules_b
WHERE id = p_rul_id;
SELECT DECODE(p_frequency,'M',1,'Q',3,'S',6,'A',12) months_per_period
FROM DUAL;
SELECT end_date,
term_duration
INTO l_contract_end_date,
l_term
FROM okc_k_headers_b chr,
okl_k_headers khr
WHERE chr.id = p_chr_id
AND chr.id = khr.id;
SELECT DECODE(p_payment_frequency, 'A', 12, 'S', 6, 'Q', 3, 'M', 1)
INTO l_mpp
FROM dual;
SELECT id
FROM okc_rule_groups_b
WHERE rgd_code = 'LALEVL' AND cle_id = p_cle_id;
SELECT id, object1_id1 payment_type_id, rule_information2 rate_type
FROM okc_rules_b
WHERE rgp_id = p_rgp_id AND rule_information_category = 'LASLH';
SELECT
ID
FROM OKC_RULE_GROUPS_V RG WHERE
RG.DNZ_CHR_ID = P_CHR_ID AND RG.CHR_ID IS NULL
AND RGD_CODE = 'LALEVL'
AND RG.CLE_ID = P_CLE_ID;
SELECT lse.lty_code
INTO l_lty_code
FROM okc_k_lines_b cle,
okc_line_styles_b lse
WHERE cle.id = p_cle_id
AND cle.lse_id = lse.id;
SELECT pricing_method_code,
pricing_engine_code
INTO l_pricing_method,
l_pricing_engine
FROM okl_so_plan_details_uv
WHERE payment_plan_id = p_cle_id;
SELECT start_date INTO l_start_date FROM okc_k_lines_b where id = p_cle_id;
l_update_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
m BINARY_INTEGER := 1; -- update table index
SELECT olrb.SOURCE_LINE_ID,
olrb.amount
FROM okl_line_relationships_b olrb
WHERE olrb.RELATED_LINE_ID = lp_fee_srv_id
AND olrb.RELATED_LINE_TYPE = p_line_type
AND olrb.SOURCE_LINE_TYPE= 'ASSET';
SELECT NVL(amount, 0)
INTO l_line_amount
FROM okl_k_lines
WHERE id = p_cle_id;
SELECT currency_code
INTO l_currency_code
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT NVL(oec, 0)
INTO l_asset_oec
FROM okl_k_lines
WHERE id = l_link_asset_tbl(i).fin_asset_id;
SELECT NVL(oec, 0)
INTO l_asset_oec
FROM okl_k_lines
WHERE id = l_link_asset_tbl(i).fin_asset_id;
SELECT txl.asset_number
INTO l_create_line_item_tbl(k).name
FROM okc_k_lines_b cle,
okc_line_styles_b lse,
okl_txl_assets_b txl
WHERE cle.id = txl.kle_id
AND cle.lse_id = lse.id
AND lse.lty_code = 'FIXED_ASSET'
AND cle.cle_id = l_link_asset_tbl(i).fin_asset_id;
SELECT id
FROM okc_rule_groups_b
WHERE rgd_code = 'LAFEXP' AND cle_id = p_cle_id;
SELECT id, rule_information1 periods, rule_information2 periodic_amount
FROM okc_rules_b
WHERE rgp_id = p_rgp_id AND rule_information_category = 'LAFEXP';
SELECT id, object1_id1 frequency
FROM okc_rules_b
WHERE rgp_id = p_rgp_id AND rule_information_category = 'LAFREQ';
SELECT ID,
INV_ITEM_ID,
EFFECTIVE_FROM,
SUPPLIER_ID
FROM okl_services_b osb
WHERE osb.PARENT_OBJECT_CODE = 'LEASEQUOTE'
AND osb.PARENT_OBJECT_ID = p_qte_id;
SELECT ocf.STY_ID payment_type_id,
ocf.DUE_ARREARS_YN Arrears_YN,
cfl.FQY_CODE Frequency_Code,
cfl.START_DATE,
cfl.STUB_DAYS,
cfl.STUB_AMOUNT,
cfl.NUMBER_OF_PERIODS,
cfl.AMOUNT
FROM OKL_CASH_FLOW_OBJECTS cfo,
OKL_CASH_FLOWS ocf,
OKL_CASH_FLOW_LEVELS cfl
WHERE cfl.caf_id = ocf.ID
AND ocf.CFO_ID = cfo.ID
AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'
AND cfo.SOURCE_ID = p_service_id
AND ocf.cft_code = 'PAYMENT_SCHEDULE'
-- sechawla 05-nov-09 Bug 9044309
ORDER BY
cfl.START_DATE;
SELECT ocf.STY_ID payment_type_id,
ocf.DUE_ARREARS_YN Arrears_YN,
cfl.FQY_CODE Frequency_Code,
cfl.START_DATE,
cfl.STUB_DAYS,
cfl.STUB_AMOUNT,
cfl.NUMBER_OF_PERIODS,
cfl.AMOUNT
FROM OKL_CASH_FLOW_OBJECTS cfo,
OKL_CASH_FLOWS ocf,
OKL_CASH_FLOW_LEVELS cfl
WHERE cfl.caf_id = ocf.ID
AND ocf.CFO_ID = cfo.ID
AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'
AND cfo.SOURCE_ID = p_service_id
AND ocf.cft_code = 'OUTFLOW_SCHEDULE';
l_payment_levels_tbl.DELETE;
l_expense_levels_tbl.DELETE;
SELECT ID,
STREAM_TYPE_ID,
FEE_TYPE ,
RATE_CARD_ID,
RATE_TEMPLATE_ID,
EFFECTIVE_FROM,
EFFECTIVE_TO,
SUPPLIER_ID,
ROLLOVER_QUOTE_ID,
INITIAL_DIRECT_COST,
FEE_AMOUNT AMOUNT,
FEE_PURPOSE_CODE
FROM okl_fees_b ofb
WHERE ofb.PARENT_OBJECT_CODE = 'LEASEQUOTE'
AND ofb.PARENT_OBJECT_ID = p_qte_id;
SELECT ocf.STY_ID payment_type_id,
ocf.DUE_ARREARS_YN Arrears_YN,
cfl.FQY_CODE Frequency_Code,
cfl.START_DATE,
cfl.STUB_DAYS,
cfl.STUB_AMOUNT,
cfl.NUMBER_OF_PERIODS,
cfl.AMOUNT
FROM OKL_CASH_FLOW_OBJECTS cfo,
OKL_CASH_FLOWS ocf,
OKL_CASH_FLOW_LEVELS cfl
WHERE cfl.caf_id = ocf.ID
AND ocf.CFO_ID = cfo.ID
AND cfo.SOURCE_TABLE = 'OKL_FEES_B'
AND ocf.CFT_CODE ='PAYMENT_SCHEDULE'
AND cfo.SOURCE_ID = p_fee_id
-- sechawla 5-nov-09 : Bug 9044309
ORDER BY
cfl.START_DATE;
SELECT ocf.STY_ID payment_type_id,
ocf.DUE_ARREARS_YN Arrears_YN,
cfl.FQY_CODE Frequency_Code,
cfl.START_DATE,
cfl.STUB_DAYS,
cfl.STUB_AMOUNT,
cfl.NUMBER_OF_PERIODS,
cfl.AMOUNT
FROM OKL_CASH_FLOW_OBJECTS cfo,
OKL_CASH_FLOWS ocf,
OKL_CASH_FLOW_LEVELS cfl
WHERE cfl.caf_id = ocf.ID
AND ocf.CFO_ID = cfo.ID
AND cfo.SOURCE_TABLE = 'OKL_FEES_B'
AND ocf.CFT_CODE ='OUTFLOW_SCHEDULE'
AND cfo.SOURCE_ID = p_fee_id;
SELECT SUM(NVL(olrb.origination_income,0)) origination_income
FROM okl_line_relationships_b olrb
WHERE olrb.RELATED_LINE_ID = p_inc_fee_id
AND olrb.RELATED_LINE_TYPE = 'INCOME'
AND olrb.SOURCE_LINE_TYPE= 'ASSET';
SELECT start_date,
end_date
INTO l_k_effective_from,
l_k_effective_to
FROM okc_k_headers_b
WHERE id = p_chr_id;
l_payment_levels_tbl.DELETE;
SELECT cle.id MODEL_LINE_ID
FROM okc_k_lines_b cle,
okc_line_styles_b cls
WHERE cle.cle_id = p_fin_line_id
AND cle.lse_id = cls.id
AND cls.lty_code = 'ITEM';
SELECT name
FROM OKC_K_LINES_V
WHERE id = p_fin_line_id;
SELECT oab.ID,
oab.ASSET_NUMBER,
oab.INSTALL_SITE_ID,
oab.RATE_CARD_ID,
oab.RATE_TEMPLATE_ID,
oab.OEC,
oab.END_OF_TERM_VALUE_DEFAULT,
oab.END_OF_TERM_VALUE,
oab.OEC_PERCENTAGE,
oab.DESCRIPTION,
oacb.INV_ITEM_ID,
oacb.SUPPLIER_ID,
oacb.PRIMARY_COMPONENT,
oacb.UNIT_COST,
oacb.NUMBER_OF_UNITS,
oacb.MANUFACTURER_NAME,
oacb.YEAR_MANUFACTURED,
oacb.MODEL_NUMBER,
oacb.id qte_add_on_id
FROM okl_assets_v oab,
okl_asset_components_b oacb
WHERE oab.ID = oacb.ASSET_ID
AND oab.PARENT_OBJECT_CODE = 'LEASEQUOTE'
AND oacb.PRIMARY_COMPONENT = 'NO'
AND oacb.ASSET_ID = p_ast_id;
l_cre_clev_tbl.DELETE;
l_cre_cimv_tbl.DELETE;
l_cre_klev_tbl.DELETE;
SELECT oab.ID asset_id
FROM okl_assets_v oab,
okl_asset_components_b oacb
WHERE oab.ID = oacb.ASSET_ID
AND oab.PARENT_OBJECT_CODE = 'LEASEQUOTE'
AND oacb.PRIMARY_COMPONENT = 'YES'
AND oab.PARENT_OBJECT_ID = p_qte_id;
SELECT ADJUSTMENT_SOURCE_ID,
VALUE,
SUPPLIER_ID,
default_subsidy_amount
FROM okl_cost_adjustments_b
WHERE PARENT_OBJECT_CODE = 'ASSET'
AND ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
AND PARENT_OBJECT_ID = p_ast_id;
SELECT
id
,parent_object_code
,parent_object_id
,adjustment_source_type
,adjustment_source_id
,basis
,value
,processing_type
,supplier_id
,default_subsidy_amount
,short_description
,description
,comments
,percent_basis_value
FROM OKL_COST_ADJUSTMENTS_V
WHERE parent_object_id = p_ast_id
AND parent_object_code = 'ASSET'
AND adjustment_source_type = 'DOWN_PAYMENT';
SELECT ASSET_NUMBER
INTO l_asset_number
FROM OKL_ASSET_ADJUST_UV
WHERE ID = p_clev_fin_rec.id;
SELECT oec
INTO l_oec
FROM OKL_K_LINES
WHERE ID = p_clev_fin_rec.id;
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.Okl_La_Asset_Pvt.update_Fin_Cap_Cost'
,'begin debug call update_Fin_Cap_Cost');
Okl_La_Asset_Pvt.update_Fin_Cap_Cost(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
'N',
l_asset_number,
l_top_line_id,
l_dnz_chr_id,
l_capital_reduction,
l_capital_reduction_percent,
l_oec,
l_cap_down_pay_yn,
l_down_payment_receiver
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.Okl_La_Asset_Pvt.update_Fin_Cap_Cost'
,'end debug call update_Fin_Cap_Cost');
SELECT
id
,parent_object_code
,parent_object_id
,adjustment_source_type
,adjustment_source_id
,basis
,value
,processing_type
,supplier_id
,default_subsidy_amount
,short_description
,description
,comments
,percent_basis_value
FROM OKL_COST_ADJUSTMENTS_V
WHERE parent_object_id = p_ast_id
AND parent_object_code = 'ASSET'
AND adjustment_source_type = 'TRADEIN';
SELECT ASSET_NUMBER
INTO l_tradein_rec.asset_number
FROM OKL_ASSET_ADJUST_UV
WHERE ID = p_clev_fin_rec.id;
l_update_date DATE;
select ASST_ADD_BOOK_TYPE_CODE
from OKL_system_params ;
SELECT oab.ID,
oab.ASSET_NUMBER,
oab.INSTALL_SITE_ID,
oab.RATE_CARD_ID,
oab.RATE_TEMPLATE_ID,
oab.OEC,
oab.END_OF_TERM_VALUE_DEFAULT,
oab.END_OF_TERM_VALUE,
oab.OEC_PERCENTAGE,
oab.SHORT_DESCRIPTION,
oacb.INV_ITEM_ID,
oacb.SUPPLIER_ID,
oacb.PRIMARY_COMPONENT,
oacb.UNIT_COST,
oacb.NUMBER_OF_UNITS,
oacb.MANUFACTURER_NAME,
oacb.YEAR_MANUFACTURED,
oacb.MODEL_NUMBER
FROM okl_assets_v oab,
okl_asset_components_b oacb
WHERE oab.ID = oacb.ASSET_ID
AND oab.PARENT_OBJECT_CODE = 'LEASEQUOTE'
AND oacb.PRIMARY_COMPONENT = 'YES'
AND oab.PARENT_OBJECT_ID = p_qte_id;
SELECT ocf.STY_ID payment_type_id,
ocf.DUE_ARREARS_YN Arrears_YN,
cfl.FQY_CODE Frequency_Code,
cfl.START_DATE,
cfl.STUB_DAYS,
cfl.STUB_AMOUNT,
cfl.NUMBER_OF_PERIODS,
cfl.AMOUNT
FROM OKL_CASH_FLOW_OBJECTS cfo,
OKL_CASH_FLOWS ocf,
OKL_CASH_FLOW_LEVELS cfl
WHERE cfl.caf_id = ocf.ID
AND ocf.CFO_ID = cfo.ID
AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
AND cfo.OTY_CODE = 'QUOTED_ASSET'
AND cfo.SOURCE_ID = p_ast_id
-- sechawla 5-nov-09 Bug 9044309
ORDER BY
cfl.START_DATE;
SELECT ocf.STY_ID payment_type_id,
ocf.DUE_ARREARS_YN Arrears_YN,
cfl.FQY_CODE Frequency_Code,
cfl.START_DATE,
cfl.STUB_DAYS,
cfl.STUB_AMOUNT,
cfl.NUMBER_OF_PERIODS,
cfl.AMOUNT
FROM OKL_CASH_FLOW_OBJECTS cfo,
OKL_CASH_FLOWS ocf,
OKL_CASH_FLOW_LEVELS cfl
WHERE cfl.caf_id = ocf.ID
AND ocf.CFO_ID = cfo.ID
AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
AND cfo.OTY_CODE = 'QUOTED_ASSET_DOWN_PAYMENT'
AND cfo.SOURCE_ID = p_ast_id;
SELECT ocf.STY_ID payment_type_id,
ocf.DUE_ARREARS_YN Arrears_YN,
cfl.FQY_CODE Frequency_Code,
cfl.START_DATE,
cfl.STUB_DAYS,
cfl.STUB_AMOUNT,
cfl.NUMBER_OF_PERIODS,
cfl.AMOUNT
FROM OKL_CASH_FLOW_OBJECTS cfo,
OKL_CASH_FLOWS ocf,
OKL_CASH_FLOW_LEVELS cfl
WHERE cfl.caf_id = ocf.ID
AND ocf.CFO_ID = cfo.ID
AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
AND cfo.OTY_CODE = 'QUOTED_ASSET_PROPERTY_TAX'
AND cfo.SOURCE_ID = p_ast_id;
SELECT ocf.STY_ID payment_type_id,
ocf.DUE_ARREARS_YN Arrears_YN,
cfl.FQY_CODE Frequency_Code,
cfl.START_DATE,
cfl.STUB_DAYS,
cfl.STUB_AMOUNT,
cfl.NUMBER_OF_PERIODS,
cfl.AMOUNT
FROM OKL_CASH_FLOW_OBJECTS cfo,
OKL_CASH_FLOWS ocf,
OKL_CASH_FLOW_LEVELS cfl
WHERE cfl.caf_id = ocf.ID
AND ocf.CFO_ID = cfo.ID
AND cfo.SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
AND cfo.SOURCE_ID = p_qte_id;
SELECT TL.DESCRIPTION DESCRIPTION
FROM MTL_SYSTEM_ITEMS_TL TL
WHERE TL.ORGANIZATION_ID = p_organization_id
AND TL.INVENTORY_ITEM_ID = p_inv_itm_id
AND TL.LANGUAGE = USERENV('LANG');
SELECT eoth.eot_type_code
FROM OKL_FE_EO_TERM_VERS EOTV,
OKL_FE_EO_TERMS_ALL_B EOTH,
OKL_LEASE_QUOTES_B QTE
WHERE QTE.END_OF_TERM_OPTION_ID = EOTV.END_OF_TERM_VER_ID
AND EOTV.END_OF_TERM_ID = EOTH.END_OF_TERM_ID
AND QTE.ID = p_qte_id;
SELECT sum(cdj.value) total_tradein
FROM OKL_COST_ADJUSTMENTS_b cdj,
OKL_ASSETS_B ast
WHERE cdj.parent_object_id = ast.id
AND cdj.parent_object_code = 'ASSET'
AND cdj.adjustment_source_type = 'TRADEIN'
AND ast.parent_object_id = p_qte_id
AND ast.parent_object_code ='LEASEQUOTE';
SELECT cdj.description
FROM OKL_COST_ADJUSTMENTS_V cdj,
OKL_ASSETS_B ast
WHERE cdj.parent_object_id = ast.id
AND cdj.parent_object_code = 'ASSET'
AND cdj.adjustment_source_type = 'TRADEIN'
AND ast.parent_object_id = p_qte_id
AND ast.parent_object_code ='LEASEQUOTE'
AND rownum = 1;
SELECT mtl.asset_category_id
FROM mtl_system_items_b mtl,
okx_asst_catgrs_v cat
WHERE inventory_item_id = cp_inv_item_id
AND organization_id = cp_inv_org_id
AND cat.id1 = mtl.asset_category_id;
SELECT def.deprn_method
, (def.adjusted_rate * 100) deprn_rate
, NVL(mth.life_in_months,def.life_in_months) life_in_months
FROM fa_category_book_defaults def
, fa_methods mth
WHERE def.book_type_code = cp_bk_type_code
AND def.category_id = cp_category_id
AND cp_inservice_date BETWEEN def.start_dpis AND Nvl(def.end_dpis, cp_inservice_date)
AND mth.method_code (+) = def.deprn_method
AND mth.life_in_months (+) = cp_term;
l_payment_levels_tbl.DELETE;
l_payment_levels_tbl.DELETE;
l_payment_levels_tbl.DELETE;
okl_la_tradein_pvt.update_contract( 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_chr_id => l_chr_id,
p_tradein_date => l_lapv_rec.expected_start_date,
p_tradein_amount => l_ti_amt,
p_tradein_desc => l_ti_desc);
l_pym_tbl(l_pymnt_counter).UPDATE_TYPE := 'CREATE';
p_update_type => 'UPDATE',
x_rulv_tbl => lx_rulv_tbl);
SELECT olav.ID,olvv.CONTRACT_TEMPLATE_ID
FROM okl_leaseapp_templ_versions_v olvv,
okl_lease_applications_v olav
WHERE olav.leaseapp_template_id = olvv.ID
AND olav.ID = p_lap_id;
SELECT rgp.id
FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs
WHERE rgp.dnz_chr_id = p_chr_tmp_id
AND rgp.rgd_code = rg_defs.rgd_code
AND rg_defs.scs_code = 'LEASE'
AND rgp.cle_id IS NULL
AND rgp.rgd_code NOT IN ('LATOWN','CURRENCY');
SELECT COUNT(1)
FROM okc_k_party_roles_v
WHERE dnz_chr_id = p_chr_id
AND chr_id = p_chr_id
AND rle_code = G_RLE_CODE
AND object1_id1 = p_customer_id;
SELECT access_level
FROM OKC_ROLE_SOURCES
WHERE rle_code = p_rle_code
AND buy_or_sell = 'S';
SELECT cpl.id, cpl.object1_id1
FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES
WHERE dnz_chr_id = p_khr_id
AND cpl.rle_code = ROLES.rle_code
AND cpl.rle_code = 'OKL_VENDOR'
AND ROLES.scs_code = 'LEASE'
AND cpl.cle_id IS NULL;
SELECT olvv.contract_template_id
FROM okl_leaseapp_templ_versions_b olvv,
okl_lease_applications_b olav
WHERE olav.leaseapp_template_id = olvv.ID -- lease app stores the template version id
AND olav.ID = p_lap_id
AND EXISTS (SELECT 1
FROM okl_k_headers khr
WHERE khr.ID = olvv.contract_template_id
AND khr.template_type_code = 'CONTRACT') -- Consider only contract templates and not lease app contract templates
;
SELECT hzp.party_name, credreq.trx_amount amount_requested, gdata.*
FROM ar_cmgt_credit_requests credreq,
ar_cmgt_guarantor_data gdata,
hz_parties hzp
WHERE gdata.credit_request_id = credreq.credit_request_id
AND credreq.source_column3 = 'LEASEAPP'
AND credreq.source_column1 = cp_lap_id
AND hzp.party_id = gdata.party_id;
SELECT 1
FROM okc_k_party_roles_b p_role
WHERE p_role.dnz_chr_id = p_chr_id
AND p_role.rle_code = p_rle_code
AND p_role.object1_id1 = p_object1_id1;
SELECT p_role.ID,
p_role.object1_id1,
p_role.object1_id2,
p_role.jtot_object1_code,
p_role.rle_code
FROM okc_k_party_roles_b p_role
WHERE p_role.dnz_chr_id = p_chr_id
AND p_role.rle_code = p_rle_code;
SELECT p_role.ID,
p_role.object1_id1,
p_role.object1_id2,
p_role.jtot_object1_code,
p_role.rle_code
FROM okc_k_party_roles_b p_role
WHERE p_role.dnz_chr_id = p_chr_id
AND (p_role.rle_code NOT IN ('LESSEE', 'LESSOR', 'OKL_VENDOR')
OR (p_role.rle_code = 'GUARANTOR'
AND p_role.jtot_object1_code= 'OKX_PARTY'
AND p_role.object1_id1 NOT IN ( SELECT gdata.PARTY_ID
FROM ar_cmgt_credit_requests credreq,
ar_cmgt_guarantor_data gdata
WHERE gdata.credit_request_id = credreq.credit_request_id
AND credreq.source_column3 = 'LEASEAPP'
AND credreq.source_column1 = cp_lap_id
)
)
);
SELECT rgrdfs.id
from okc_k_headers_b chr,
okc_subclass_roles sre,
okc_role_sources rse,
okc_subclass_rg_defs rgdfs,
okc_rg_role_defs rgrdfs
where chr.id = cp_chr_id
and sre.scs_code = chr.scs_code
and sre.rle_code = rse.rle_code
and rse.rle_code = 'GUARANTOR'
and rse.buy_or_sell = chr.buy_or_sell
and rgdfs.scs_code = chr.scs_code
and rgdfs.rgd_code = 'LAGRDT'
and rgrdfs.srd_id = rgdfs.id
and rgrdfs.sre_id = sre.id;
SELECT PARTY_SITE_ID
FROM HZ_PARTY_SITES
WHERE party_id = cp_party_id
AND status = 'A'
AND identifying_address_flag = 'Y' ;
l_rulv_tbl.DELETE;
SELECT qcl.id
FROM OKC_QA_CHECK_LISTS_TL qcl,
OKC_QA_CHECK_LISTS_B qclv
WHERE qclv.Id = qcl.id
AND UPPER(qcl.name) = 'OKL LA QA CHECK LIST'
AND qcl.LANGUAGE = USERENV('LANG');
SELECT chr.id , chr.description, khr.ATTRIBUTE_CATEGORY
, khr.ATTRIBUTE1, khr.ATTRIBUTE2, khr.ATTRIBUTE3, khr.ATTRIBUTE4, khr.ATTRIBUTE5, khr.ATTRIBUTE6
, khr.ATTRIBUTE7, khr.ATTRIBUTE8, khr.ATTRIBUTE9, khr.ATTRIBUTE10, khr.ATTRIBUTE11, khr.ATTRIBUTE12
, khr.ATTRIBUTE13, khr.ATTRIBUTE14, khr.ATTRIBUTE15
FROM okl_leaseapp_templ_versions_b olvv,
okl_lease_applications_b olav,
okc_k_headers_v chr,
okl_k_headers khr
WHERE olav.leaseapp_template_id = olvv.ID -- lease app stores the template version id
AND olav.ID = p_lap_id
AND chr.id = khr.id
AND chr.id = olvv.contract_template_id
AND EXISTS (SELECT 1
FROM okl_k_headers khr
WHERE khr.ID = olvv.contract_template_id
AND khr.template_type_code = 'CONTRACT') -- Consider only contract templates and not lease app contract templates
;
lp_chrv_rec.deleted_yn := 'N';
SELECT 'Y'
FROM okc_k_headers_b
where contract_number = lc_contract_number;
SELECT count(1)
FROM okc_k_headers_b
WHERE contract_number like p_contract_number || '%';
SELECT parent_object_id
FROM okl_lease_quotes_b
WHERE id = p_parent_object_id;
OKC_COPY_CONTRACT_PVT.G_PARTY.delete;
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.update_leaseapp_status'
,'begin debug call update_leaseapp_status');
update_leaseapp_status(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_lap_id => l_lapv_rec.id);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.update_leaseapp_status'
,'end debug call update_leaseapp_status');