eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_LEASE_QUOTES_B

Line 1068: FROM okl_lease_quotes_b lqh

1064: SELECT gts.days_in_month_code days_in_month,
1065: gts.days_in_yr_code days_in_year,
1066: gts.id gts_id,
1067: pdt.id pdt_id
1068: FROM okl_lease_quotes_b lqh
1069: ,okl_products pdt
1070: ,okl_ae_tmpt_sets aes
1071: ,okl_st_gen_tmpt_sets gts
1072: WHERE lqh.product_id = pdt.id

Line 6382: FROM okl_lease_quotes_b qte

6378: qte.target_amount target_amount,
6379: qte.term term,
6380: qte.structured_pricing structured_pricing,
6381: qte.pricing_method pricing_method
6382: FROM okl_lease_quotes_b qte
6383: WHERE qte.id = qteid;
6384: quote_rec quote_csr%ROWTYPE;
6385: -- Cursor to fetch the ID of the CFL defined at Quote Level !
6386: CURSOR get_cfl_id_csr( qteId NUMBER )

Line 6397: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'

6393: OKL_CASH_FLOWS cfh,
6394: OKL_CASH_FLOW_OBJECTS cfo
6395: WHERE cfl.caf_id = cfh.id
6396: AND cfh.cfo_id = cfo.id
6397: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
6398: AND cfo.source_id = qteId
6399: ORDER BY cfl.start_date;
6400: -- Cursor to fetch the Details from the Asset
6401: CURSOR asset_details_csr( p_astId NUMBER )

Line 6617: -- target_amount column either from OKL_LEASE_QUOTES_B/OKL_ASSETS_B/OKL_FEES_B

6613: RAISE OKL_API.G_EXCEPTION_ERROR;
6614: END IF;
6615: l_cash_flow_det_tbl(1).number_of_periods := quote_rec.term / l_months_factor;
6616: --l_cash_flow_det_tbl(1).amount has been already fetched from the
6617: -- target_amount column either from OKL_LEASE_QUOTES_B/OKL_ASSETS_B/OKL_FEES_B
6618: ELSE
6619: -- When the LQ is being priced for SM pricng method, on selecting the SRT
6620: -- as the pricing option, the user will be shown to enter the Cash flow levels too.
6621: -- Hence, retrieve the cash flow levels even when the pricing option is SRT.

Line 6759: p_cf_source_type => p_cf_source, -- Pass the source type OKL_ASSETS_B/OKL_LEASE_QUOTES_B

6755: p_init_msg_list => p_init_msg_list,
6756: x_return_status => l_return_status,
6757: x_msg_count => x_msg_count,
6758: x_msg_data => x_msg_data,
6759: p_cf_source_type => p_cf_source, -- Pass the source type OKL_ASSETS_B/OKL_LEASE_QUOTES_B
6760: p_qq_id => p_id, -- Pass the id of the Assets/ Lease Quote !
6761: x_days_in_month => x_days_in_month,
6762: x_days_in_year => x_days_in_year,
6763: x_cash_flow_rec => l_cash_flow_rec, -- Cash Flow Record

Line 8278: FROM OKL_LEASE_QUOTES_B qte

8274: qte.rate_template_id rate_template_id,
8275: qte.structured_pricing structured_pricing,
8276: qte.line_level_pricing line_level_pricing,
8277: qte.target_arrears_yn target_arrears
8278: FROM OKL_LEASE_QUOTES_B qte
8279: WHERE qte.id = qteid;
8280: quote_rec quote_csr%ROWTYPE;
8281: -- Cursor to fetch the Assets Details for a Lease Quote
8282: -- and SRT attached to the Asset ( if any .. )

Line 8293: okl_lease_quotes_b qte

8289: ast.structured_pricing structured_pricing,
8290: ast.rate_template_id rate_template_id,
8291: ast.target_arrears target_arrears
8292: FROM okl_assets_b ast,
8293: okl_lease_quotes_b qte
8294: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8295: ast.parent_object_id = qte.id AND
8296: qte.id = qteid;
8297: CURSOR c_asset_comp_csr( p_asset_id NUMBER) IS

Line 8536: FROM OKL_LEASE_QUOTES_B qte

8532: qte.target_frequency target_frequency,
8533: qte.target_arrears_yn target_arrears,
8534: qte.product_id,
8535: qte.sub_iir -- Yield used while calculating the payments @ Asset Level
8536: FROM OKL_LEASE_QUOTES_B qte
8537: WHERE qte.id = qteid;
8538: quote_rec quote_csr%ROWTYPE;
8539:
8540: --Bug 5884825 PAGARG start

Line 8545: FROM OKL_LEASE_QUOTES_B QTE

8541: --Cursor to fetch product name
8542: CURSOR product_name_csr(qteid NUMBER)
8543: IS
8544: SELECT PDT.NAME PRODUCTNAME
8545: FROM OKL_LEASE_QUOTES_B QTE
8546: , OKL_PRODUCTS PDT
8547: WHERE QTE.PRODUCT_ID = PDT.ID
8548: AND QTE.ID = QTEID;
8549: --Bug 5884825 PAGARG end

Line 8594: okl_lease_quotes_b qte

8590: ast.asset_number name,
8591: ast.target_frequency target_frequency,
8592: ast.target_arrears target_arrears
8593: FROM okl_assets_b ast,
8594: okl_lease_quotes_b qte
8595: WHERE ast.parent_object_code = 'LEASEQUOTE'
8596: AND ast.parent_object_id = qte.id
8597: AND qte.id = qteid
8598: AND ast.id = ast_fee_id

Line 8613: okl_lease_quotes_b qte

8609: fee.fee_type || ' FEE' name,
8610: fee.target_frequency target_frequency,
8611: fee.target_arrears target_arrears
8612: FROM okl_fees_b fee,
8613: okl_lease_quotes_b qte
8614: WHERE fee.parent_object_code = 'LEASEQUOTE'
8615: AND fee.parent_object_id = qte.id
8616: AND qte.id = qteid
8617: AND fee.id = ast_fee_id;

Line 8634: okl_lease_quotes_b qte,

8630: cmp.unit_cost,
8631: cmp.number_of_units,
8632: cmp.primary_component
8633: FROM okl_assets_b ast,
8634: okl_lease_quotes_b qte,
8635: okl_asset_components_b cmp
8636: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8637: ast.parent_object_id = qte.id AND
8638: qte.id = qteid AND

Line 8653: okl_lease_quotes_b qte,

8649: -- Start : DJANASWA : Bug# 6347118
8650: nvl(adj.value,adj.default_subsidy_amount) value
8651: -- End : DJANASWA : Bug# 6347118
8652: FROM okl_assets_b ast,
8653: okl_lease_quotes_b qte,
8654: okl_cost_adjustments_b adj
8655: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8656: ast.parent_object_id = qte.id AND
8657: qte.id = qteid AND

Line 8668: FROM okl_lease_quotes_b lq,

8664: ,lopp.prospect_id prospect_id
8665: ,lopp.cust_acct_id cust_acct_id
8666: ,lopp.sales_territory_id sales_territory_id
8667: ,lopp.currency_code currency_code
8668: FROM okl_lease_quotes_b lq,
8669: okl_lease_opportunities_b lopp
8670: WHERE parent_object_code = 'LEASEOPP'
8671: AND parent_object_id = lopp.id
8672: AND lq.id = p_lq_id;

Line 8681: FROM okl_lease_quotes_b lq,

8677: ,lapp.prospect_id prospect_id
8678: ,lapp.cust_acct_id cust_acct_id
8679: ,lapp.sales_territory_id sales_territory_id
8680: ,lapp.currency_code currency_code
8681: FROM okl_lease_quotes_b lq,
8682: okl_lease_applications_b lapp
8683: WHERE parent_object_code = 'LEASEAPP'
8684: AND parent_object_id = lapp.id
8685: AND lq.id = p_lq_id;

Line 8757: FROM OKL_LEASE_QUOTES_B lq,

8753: ,eot.end_of_term_name
8754: ,eot.eot_type_code eot_type_code
8755: ,eot.end_of_term_id end_of_term_id
8756: ,eotversion.end_of_term_ver_id
8757: FROM OKL_LEASE_QUOTES_B lq,
8758: okl_fe_eo_term_vers eotversion,
8759: okl_fe_eo_terms_all_b eot
8760: WHERE lq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
8761: AND eot.end_of_term_id = eotversion.end_of_term_id

Line 8823: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;

8819: l_target_arrears_yn VARCHAR2(30);
8820: l_sty_id NUMBER;
8821: l_srt_id NUMBER;
8822: l_adj_type VARCHAR2(30);
8823: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;
8824: l_missing_pmnts BOOLEAN;
8825: l_asset_number VARCHAR2(15);
8826: l_fee_name VARCHAR2(150);
8827: BEGIN

Line 10301: CURSOR all_assets_csr( p_qte_id IN okl_lease_quotes_b.id%TYPE)

10297: x_cfl_tbl OUT NOCOPY OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type,
10298: x_solved OUT NOCOPY VARCHAR2)
10299: IS
10300: -- Cursor to fetch all the Assets in a Lease Quote
10301: CURSOR all_assets_csr( p_qte_id IN okl_lease_quotes_b.id%TYPE)
10302: IS
10303: SELECT ast.id ast_id,
10304: ast.asset_number ast_number
10305: FROM okl_assets_b ast,

Line 10306: okl_lease_quotes_b qte

10302: IS
10303: SELECT ast.id ast_id,
10304: ast.asset_number ast_number
10305: FROM okl_assets_b ast,
10306: okl_lease_quotes_b qte
10307: WHERE ast.parent_object_code = 'LEASEQUOTE'
10308: AND ast.parent_object_id = qte.id
10309: AND qte.id = p_qte_id;
10310: all_assets_rec all_assets_csr%ROWTYPE;

Line 10313: p_qte_id OKL_LEASE_QUOTES_B.ID%TYPE)

10309: AND qte.id = p_qte_id;
10310: all_assets_rec all_assets_csr%ROWTYPE;
10311: -- Cursor to fetch the payment structure defined/derieved of an asset
10312: CURSOR ast_payments_csr( p_ast_id OKL_ASSETS_B.ID%TYPE,
10313: p_qte_id OKL_LEASE_QUOTES_B.ID%TYPE)
10314: IS
10315: SELECT cfl.fqy_code frequency,
10316: caf.due_arrears_yn adv_arrears,
10317: caf.sty_id sty_id,

Line 10523: FROM okl_lease_quotes_b qte

10519: qte.parent_object_id,
10520: qte.object_version_number,
10521: qte.reference_number,
10522: qte.product_id
10523: FROM okl_lease_quotes_b qte
10524: WHERE qte.id = qteid;
10525: quote_rec quote_csr%ROWTYPE;
10526:
10527: CURSOR c_strm_type ( qteID NUMBER, expStartDate DATE) IS

Line 10534: OKL_LEASE_QUOTES_B QUOTE

10530: STRM.START_DATE,
10531: STRM.END_DATE,
10532: STRM.STY_PURPOSE
10533: FROM OKL_STRM_TMPT_PRIMARY_UV STRM,
10534: OKL_LEASE_QUOTES_B QUOTE
10535: WHERE STY_PURPOSE = 'RENT'
10536: AND START_DATE <= expStartDate
10537: AND NVL(END_DATE, expStartDate) >= expStartDate
10538: AND STRM.PDT_ID = QUOTE.PRODUCT_ID

Line 10569: okl_lease_quotes_b qte

10565: ast.lease_rate_factor lease_rate_factor,
10566: ast.target_arrears target_arrears,
10567: ast.oec_percentage oec_percentage
10568: FROM okl_assets_b ast,
10569: okl_lease_quotes_b qte
10570: WHERE ast.parent_object_code = 'LEASEQUOTE'
10571: AND ast.parent_object_id = qte.id
10572: AND qte.id = qteid
10573: UNION

Line 10588: okl_lease_quotes_b qte

10584: fee.lease_rate_factor lease_rate_factor,
10585: fee.target_arrears target_arrears,
10586: NULL oec_percentage
10587: FROM okl_fees_b fee,
10588: okl_lease_quotes_b qte
10589: WHERE fee.parent_object_code = 'LEASEQUOTE'
10590: AND fee.parent_object_id = qte.id
10591: AND qte.id = qteid;
10592: assets_rec assets_csr%ROWTYPE;

Line 10609: okl_lease_quotes_b qte,

10605: cmp.unit_cost,
10606: cmp.number_of_units,
10607: cmp.primary_component
10608: FROM okl_assets_b ast,
10609: okl_lease_quotes_b qte,
10610: okl_asset_components_b cmp
10611: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
10612: ast.parent_object_id = qte.id AND
10613: qte.id = qteid AND

Line 10628: okl_lease_quotes_b qte,

10624: -- Start : DJANASWA : Bug# 6347118
10625: nvl(adj.value,adj.default_subsidy_amount) value
10626: -- End : DJANASWA : Bug# 6347118
10627: FROM okl_assets_b ast,
10628: okl_lease_quotes_b qte,
10629: okl_cost_adjustments_b adj
10630: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
10631: ast.parent_object_id = qte.id AND
10632: qte.id = qteid AND

Line 10653: FROM okl_lease_quotes_b lq,

10649: ,lopp.prospect_id prospect_id
10650: ,lopp.cust_acct_id cust_acct_id
10651: ,lopp.sales_territory_id sales_territory_id
10652: ,lopp.currency_code currency_code
10653: FROM okl_lease_quotes_b lq,
10654: okl_lease_opportunities_b lopp
10655: WHERE parent_object_code = 'LEASEOPP'
10656: AND parent_object_id = lopp.id
10657: AND lq.id = p_lq_id;

Line 10666: FROM okl_lease_quotes_b lq,

10662: ,lapp.prospect_id prospect_id
10663: ,lapp.cust_acct_id cust_acct_id
10664: ,lapp.sales_territory_id sales_territory_id
10665: ,lapp.currency_code currency_code
10666: FROM okl_lease_quotes_b lq,
10667: okl_lease_applications_b lapp
10668: WHERE parent_object_code = 'LEASEAPP'
10669: AND parent_object_id = lapp.id
10670: AND lq.id = p_lq_id;

Line 10697: FROM OKL_LEASE_QUOTES_B lq,

10693: ,eot.end_of_term_name
10694: ,eot.eot_type_code eot_type_code
10695: ,eot.end_of_term_id end_of_term_id
10696: ,eotversion.end_of_term_ver_id
10697: FROM OKL_LEASE_QUOTES_B lq,
10698: okl_fe_eo_term_vers eotversion,
10699: okl_fe_eo_terms_all_b eot
10700: WHERE lq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
10701: AND eot.end_of_term_id = eotversion.end_of_term_id

Line 10719: FROM OKL_LEASE_QUOTES_B QTE

10715: --Bug 5884825 PAGARG start
10716: CURSOR product_name_csr(qteid NUMBER)
10717: IS
10718: SELECT PDT.NAME PRODUCTNAME
10719: FROM OKL_LEASE_QUOTES_B QTE
10720: , OKL_PRODUCTS PDT
10721: WHERE QTE.PRODUCT_ID = PDT.ID
10722: AND QTE.ID = qteid;
10723: --Bug 5884825 PAGARG end

Line 10785: l_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

10781: l_fee_outflow_cfl_tbl so_cash_flow_details_tbl_type;
10782: l_fee_inflow_caf_rec so_cash_flows_rec_type;
10783: l_fee_inflow_cfl_tbl so_cash_flow_details_tbl_type;
10784: l_adj_type VARCHAR2(30);
10785: l_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
10786: l_sp_for_assets BOOLEAN;
10787: l_an_ass_follow_lq BOOLEAN;
10788: l_lq_details_prc_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10789: l_rent_sty_id OKL_STRM_TYPE_B.ID%TYPE;

Line 10794: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;

10790: l_asset_caf_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
10791: l_asset_cfl_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10792: l_ast_level_fin_amt NUMBER;
10793: l_lq_level_fin_amt NUMBER;
10794: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;
10795: l_solved VARCHAR2(30);
10796: l_tmp_amount NUMBER;
10797: l_lq_con_cash_inflows cash_inflows_tbl_type;
10798: l_iir NUMBER;

Line 10937: p_source_table => 'OKL_LEASE_QUOTES_B',

10933: END IF;
10934: l_cfo_exists_at_lq := 'NO';
10935: FOR t_rec IN check_cfo_exists_csr(
10936: p_oty_code => 'LEASE_QUOTE',
10937: p_source_table => 'OKL_LEASE_QUOTES_B',
10938: p_source_id => p_qte_id,
10939: p_sts_code => 'CURRENT')
10940: LOOP
10941: l_cfo_exists_at_lq := t_rec.cfo_exists;

Line 14409: p_source_table => 'OKL_LEASE_QUOTES_B',

14405: -- at the Lease Quote level.
14406: l_cfo_exists_at_lq := 'NO';
14407: FOR t_rec IN check_cfo_exists_csr(
14408: p_oty_code => 'LEASE_QUOTE_CONSOLIDATED',
14409: p_source_table => 'OKL_LEASE_QUOTES_B',
14410: p_source_id => p_qte_id,
14411: p_sts_code => 'WORK')
14412: LOOP
14413: l_cfo_exists_at_lq := t_rec.cfo_exists;