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 6715: FROM okl_lease_quotes_b qte

6711: qte.target_amount target_amount,
6712: qte.term term,
6713: qte.structured_pricing structured_pricing,
6714: qte.pricing_method pricing_method
6715: FROM okl_lease_quotes_b qte
6716: WHERE qte.id = qteid;
6717: quote_rec quote_csr%ROWTYPE;
6718: -- Cursor to fetch the ID of the CFL defined at Quote Level !
6719: CURSOR get_cfl_id_csr( qteId NUMBER )

Line 6730: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'

6726: OKL_CASH_FLOWS cfh,
6727: OKL_CASH_FLOW_OBJECTS cfo
6728: WHERE cfl.caf_id = cfh.id
6729: AND cfh.cfo_id = cfo.id
6730: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
6731: AND cfo.source_id = qteId
6732: ORDER BY cfl.start_date;
6733: -- Cursor to fetch the Details from the Asset
6734: CURSOR asset_details_csr( p_astId NUMBER )

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

6946: RAISE OKL_API.G_EXCEPTION_ERROR;
6947: END IF;
6948: l_cash_flow_det_tbl(1).number_of_periods := quote_rec.term / l_months_factor;
6949: --l_cash_flow_det_tbl(1).amount has been already fetched from the
6950: -- target_amount column either from OKL_LEASE_QUOTES_B/OKL_ASSETS_B/OKL_FEES_B
6951: ELSE
6952: -- When the LQ is being priced for SM pricng method, on selecting the SRT
6953: -- as the pricing option, the user will be shown to enter the Cash flow levels too.
6954: -- Hence, retrieve the cash flow levels even when the pricing option is SRT.

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

7089: p_init_msg_list => p_init_msg_list,
7090: x_return_status => l_return_status,
7091: x_msg_count => x_msg_count,
7092: x_msg_data => x_msg_data,
7093: p_cf_source_type => p_cf_source, -- Pass the source type OKL_ASSETS_B/OKL_LEASE_QUOTES_B
7094: p_qq_id => p_id, -- Pass the id of the Assets/ Lease Quote !
7095: x_days_in_month => x_days_in_month,
7096: x_days_in_year => x_days_in_year,
7097: x_cash_flow_rec => l_cash_flow_rec, -- Cash Flow Record

Line 8612: FROM OKL_LEASE_QUOTES_B qte

8608: qte.rate_template_id rate_template_id,
8609: qte.structured_pricing structured_pricing,
8610: qte.line_level_pricing line_level_pricing,
8611: qte.target_arrears_yn target_arrears
8612: FROM OKL_LEASE_QUOTES_B qte
8613: WHERE qte.id = qteid;
8614: quote_rec quote_csr%ROWTYPE;
8615: -- Cursor to fetch the Assets Details for a Lease Quote
8616: -- and SRT attached to the Asset ( if any .. )

Line 8627: okl_lease_quotes_b qte

8623: ast.structured_pricing structured_pricing,
8624: ast.rate_template_id rate_template_id,
8625: ast.target_arrears target_arrears
8626: FROM okl_assets_b ast,
8627: okl_lease_quotes_b qte
8628: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8629: ast.parent_object_id = qte.id AND
8630: qte.id = qteid;
8631: CURSOR c_asset_comp_csr( p_asset_id NUMBER) IS

Line 8874: FROM OKL_LEASE_QUOTES_B qte

8870: qte.target_frequency target_frequency,
8871: qte.target_arrears_yn target_arrears,
8872: qte.product_id,
8873: qte.sub_iir -- Yield used while calculating the payments @ Asset Level
8874: FROM OKL_LEASE_QUOTES_B qte
8875: WHERE qte.id = qteid;
8876: quote_rec quote_csr%ROWTYPE;
8877:
8878: --Bug 5884825 PAGARG start

Line 8883: FROM OKL_LEASE_QUOTES_B QTE

8879: --Cursor to fetch product name
8880: CURSOR product_name_csr(qteid NUMBER)
8881: IS
8882: SELECT PDT.NAME PRODUCTNAME
8883: FROM OKL_LEASE_QUOTES_B QTE
8884: , OKL_PRODUCTS PDT
8885: WHERE QTE.PRODUCT_ID = PDT.ID
8886: AND QTE.ID = QTEID;
8887: --Bug 5884825 PAGARG end

Line 8932: okl_lease_quotes_b qte

8928: ast.asset_number name,
8929: ast.target_frequency target_frequency,
8930: ast.target_arrears target_arrears
8931: FROM okl_assets_b ast,
8932: okl_lease_quotes_b qte
8933: WHERE ast.parent_object_code = 'LEASEQUOTE'
8934: AND ast.parent_object_id = qte.id
8935: AND qte.id = qteid
8936: AND ast.id = ast_fee_id

Line 8952: okl_lease_quotes_b qte

8948: fee.fee_type || ' FEE' name,
8949: fee.target_frequency target_frequency,
8950: fee.target_arrears target_arrears
8951: FROM okl_fees_b fee,
8952: okl_lease_quotes_b qte
8953: WHERE fee.parent_object_code = 'LEASEQUOTE'
8954: AND fee.parent_object_id = qte.id
8955: AND qte.id = qteid
8956: AND fee.id = ast_fee_id

Line 8974: okl_lease_quotes_b qte,

8970: cmp.unit_cost,
8971: cmp.number_of_units,
8972: cmp.primary_component
8973: FROM okl_assets_b ast,
8974: okl_lease_quotes_b qte,
8975: okl_asset_components_b cmp
8976: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8977: ast.parent_object_id = qte.id AND
8978: qte.id = qteid AND

Line 8993: okl_lease_quotes_b qte,

8989: -- Start : DJANASWA : Bug# 6347118
8990: nvl(adj.value,adj.default_subsidy_amount) value
8991: -- End : DJANASWA : Bug# 6347118
8992: FROM okl_assets_b ast,
8993: okl_lease_quotes_b qte,
8994: okl_cost_adjustments_b adj
8995: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8996: ast.parent_object_id = qte.id AND
8997: qte.id = qteid AND

Line 9008: FROM okl_lease_quotes_b lq,

9004: ,lopp.prospect_id prospect_id
9005: ,lopp.cust_acct_id cust_acct_id
9006: ,lopp.sales_territory_id sales_territory_id
9007: ,lopp.currency_code currency_code
9008: FROM okl_lease_quotes_b lq,
9009: okl_lease_opportunities_b lopp
9010: WHERE parent_object_code = 'LEASEOPP'
9011: AND parent_object_id = lopp.id
9012: AND lq.id = p_lq_id;

Line 9021: FROM okl_lease_quotes_b lq,

9017: ,lapp.prospect_id prospect_id
9018: ,lapp.cust_acct_id cust_acct_id
9019: ,lapp.sales_territory_id sales_territory_id
9020: ,lapp.currency_code currency_code
9021: FROM okl_lease_quotes_b lq,
9022: okl_lease_applications_b lapp
9023: WHERE parent_object_code = 'LEASEAPP'
9024: AND parent_object_id = lapp.id
9025: AND lq.id = p_lq_id;

Line 9097: FROM OKL_LEASE_QUOTES_B lq,

9093: ,eot.end_of_term_name
9094: ,eot.eot_type_code eot_type_code
9095: ,eot.end_of_term_id end_of_term_id
9096: ,eotversion.end_of_term_ver_id
9097: FROM OKL_LEASE_QUOTES_B lq,
9098: okl_fe_eo_term_vers eotversion,
9099: okl_fe_eo_terms_all_b eot
9100: WHERE lq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
9101: AND eot.end_of_term_id = eotversion.end_of_term_id

Line 9163: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;

9159: l_target_arrears_yn VARCHAR2(30);
9160: l_sty_id NUMBER;
9161: l_srt_id NUMBER;
9162: l_adj_type VARCHAR2(30);
9163: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;
9164: l_missing_pmnts BOOLEAN;
9165: l_asset_number VARCHAR2(15);
9166: l_fee_name VARCHAR2(150);
9167: BEGIN

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

10837: x_cfl_tbl OUT NOCOPY OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type,
10838: x_solved OUT NOCOPY VARCHAR2)
10839: IS
10840: -- Cursor to fetch all the Assets in a Lease Quote
10841: CURSOR all_assets_csr( p_qte_id IN okl_lease_quotes_b.id%TYPE)
10842: IS
10843: SELECT ast.id ast_id,
10844: ast.asset_number ast_number
10845: FROM okl_assets_b ast,

Line 10846: okl_lease_quotes_b qte

10842: IS
10843: SELECT ast.id ast_id,
10844: ast.asset_number ast_number
10845: FROM okl_assets_b ast,
10846: okl_lease_quotes_b qte
10847: WHERE ast.parent_object_code = 'LEASEQUOTE'
10848: AND ast.parent_object_id = qte.id
10849: AND qte.id = p_qte_id;
10850: all_assets_rec all_assets_csr%ROWTYPE;

Line 10853: p_qte_id OKL_LEASE_QUOTES_B.ID%TYPE)

10849: AND qte.id = p_qte_id;
10850: all_assets_rec all_assets_csr%ROWTYPE;
10851: -- Cursor to fetch the payment structure defined/derieved of an asset
10852: CURSOR ast_payments_csr( p_ast_id OKL_ASSETS_B.ID%TYPE,
10853: p_qte_id OKL_LEASE_QUOTES_B.ID%TYPE)
10854: IS
10855: SELECT cfl.fqy_code frequency,
10856: caf.due_arrears_yn adv_arrears,
10857: caf.sty_id sty_id,

Line 11185: FROM OKL_LEASE_QUOTES_B LSE_QT,

11181: CURSOR get_quote_details_csr IS
11182: SELECT LSE_QT.PRODUCT_ID,
11183: LSE_QT.EXPECTED_START_DATE,
11184: PDT.DEAL_TYPE
11185: FROM OKL_LEASE_QUOTES_B LSE_QT,
11186: OKL_PRODUCT_PARAMETERS_V PDT
11187: WHERE LSE_QT.PRODUCT_ID = PDT.ID
11188: AND LSE_QT.ID = p_quote_id;
11189:

Line 11503: FROM okl_lease_quotes_b qte

11499: qte.parent_object_id,
11500: qte.object_version_number,
11501: qte.reference_number,
11502: qte.product_id
11503: FROM okl_lease_quotes_b qte
11504: WHERE qte.id = qteid;
11505: quote_rec quote_csr%ROWTYPE;
11506:
11507: CURSOR c_strm_type ( qteID NUMBER, expStartDate DATE) IS

Line 11514: OKL_LEASE_QUOTES_B QUOTE

11510: STRM.START_DATE,
11511: STRM.END_DATE,
11512: STRM.STY_PURPOSE
11513: FROM OKL_STRM_TMPT_PRIMARY_UV STRM,
11514: OKL_LEASE_QUOTES_B QUOTE
11515: WHERE STY_PURPOSE = 'RENT'
11516: AND START_DATE <= expStartDate
11517: AND NVL(END_DATE, expStartDate) >= expStartDate
11518: AND STRM.PDT_ID = QUOTE.PRODUCT_ID

Line 11549: okl_lease_quotes_b qte

11545: ast.lease_rate_factor lease_rate_factor,
11546: ast.target_arrears target_arrears,
11547: ast.oec_percentage oec_percentage
11548: FROM okl_assets_b ast,
11549: okl_lease_quotes_b qte
11550: WHERE ast.parent_object_code = 'LEASEQUOTE'
11551: AND ast.parent_object_id = qte.id
11552: AND qte.id = qteid
11553: UNION

Line 11568: okl_lease_quotes_b qte

11564: fee.lease_rate_factor lease_rate_factor,
11565: fee.target_arrears target_arrears,
11566: NULL oec_percentage
11567: FROM okl_fees_b fee,
11568: okl_lease_quotes_b qte
11569: WHERE fee.parent_object_code = 'LEASEQUOTE'
11570: AND fee.parent_object_id = qte.id
11571: AND qte.id = qteid;
11572: assets_rec assets_csr%ROWTYPE;

Line 11580: okl_lease_quotes_b qte

11576: IS
11577: SELECT srvc.id srvc_id,
11578: srvc.effective_from line_start_date
11579: FROM okl_services_b srvc,
11580: okl_lease_quotes_b qte
11581: WHERE srvc.parent_object_code = 'LEASEQUOTE'
11582: AND srvc.parent_object_id = qte.id
11583: AND qte.id = qteid;
11584:

Line 11603: okl_lease_quotes_b qte,

11599: cmp.unit_cost,
11600: cmp.number_of_units,
11601: cmp.primary_component
11602: FROM okl_assets_b ast,
11603: okl_lease_quotes_b qte,
11604: okl_asset_components_b cmp
11605: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
11606: ast.parent_object_id = qte.id AND
11607: qte.id = qteid AND

Line 11622: okl_lease_quotes_b qte,

11618: -- Start : DJANASWA : Bug# 6347118
11619: nvl(adj.value,adj.default_subsidy_amount) value
11620: -- End : DJANASWA : Bug# 6347118
11621: FROM okl_assets_b ast,
11622: okl_lease_quotes_b qte,
11623: okl_cost_adjustments_b adj
11624: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
11625: ast.parent_object_id = qte.id AND
11626: qte.id = qteid AND

Line 11647: FROM okl_lease_quotes_b lq,

11643: ,lopp.prospect_id prospect_id
11644: ,lopp.cust_acct_id cust_acct_id
11645: ,lopp.sales_territory_id sales_territory_id
11646: ,lopp.currency_code currency_code
11647: FROM okl_lease_quotes_b lq,
11648: okl_lease_opportunities_b lopp
11649: WHERE parent_object_code = 'LEASEOPP'
11650: AND parent_object_id = lopp.id
11651: AND lq.id = p_lq_id;

Line 11660: FROM okl_lease_quotes_b lq,

11656: ,lapp.prospect_id prospect_id
11657: ,lapp.cust_acct_id cust_acct_id
11658: ,lapp.sales_territory_id sales_territory_id
11659: ,lapp.currency_code currency_code
11660: FROM okl_lease_quotes_b lq,
11661: okl_lease_applications_b lapp
11662: WHERE parent_object_code = 'LEASEAPP'
11663: AND parent_object_id = lapp.id
11664: AND lq.id = p_lq_id;

Line 11691: FROM OKL_LEASE_QUOTES_B lq,

11687: ,eot.end_of_term_name
11688: ,eot.eot_type_code eot_type_code
11689: ,eot.end_of_term_id end_of_term_id
11690: ,eotversion.end_of_term_ver_id
11691: FROM OKL_LEASE_QUOTES_B lq,
11692: okl_fe_eo_term_vers eotversion,
11693: okl_fe_eo_terms_all_b eot
11694: WHERE lq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
11695: AND eot.end_of_term_id = eotversion.end_of_term_id

Line 11713: FROM OKL_LEASE_QUOTES_B QTE

11709: --Bug 5884825 PAGARG start
11710: CURSOR product_name_csr(qteid NUMBER)
11711: IS
11712: SELECT PDT.NAME PRODUCTNAME
11713: FROM OKL_LEASE_QUOTES_B QTE
11714: , OKL_PRODUCTS PDT
11715: WHERE QTE.PRODUCT_ID = PDT.ID
11716: AND QTE.ID = qteid;
11717: --Bug 5884825 PAGARG end

Line 11779: l_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

11775: l_fee_outflow_cfl_tbl so_cash_flow_details_tbl_type;
11776: l_fee_inflow_caf_rec so_cash_flows_rec_type;
11777: l_fee_inflow_cfl_tbl so_cash_flow_details_tbl_type;
11778: l_adj_type VARCHAR2(30);
11779: l_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
11780: l_sp_for_assets BOOLEAN;
11781: l_an_ass_follow_lq BOOLEAN;
11782: l_lq_details_prc_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11783: l_rent_sty_id OKL_STRM_TYPE_B.ID%TYPE;

Line 11788: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;

11784: l_asset_caf_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
11785: l_asset_cfl_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
11786: l_ast_level_fin_amt NUMBER;
11787: l_lq_level_fin_amt NUMBER;
11788: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;
11789: l_solved VARCHAR2(30);
11790: l_tmp_amount NUMBER;
11791: l_lq_con_cash_inflows cash_inflows_tbl_type;
11792: l_iir NUMBER;

Line 11980: p_source_table => 'OKL_LEASE_QUOTES_B',

11976: END IF;
11977: l_cfo_exists_at_lq := 'NO';
11978: FOR t_rec IN check_cfo_exists_csr(
11979: p_oty_code => 'LEASE_QUOTE',
11980: p_source_table => 'OKL_LEASE_QUOTES_B',
11981: p_source_id => p_qte_id,
11982: p_sts_code => 'CURRENT')
11983: LOOP
11984: l_cfo_exists_at_lq := t_rec.cfo_exists;

Line 15720: p_source_table => 'OKL_LEASE_QUOTES_B',

15716: -- at the Lease Quote level.
15717: l_cfo_exists_at_lq := 'NO';
15718: FOR t_rec IN check_cfo_exists_csr(
15719: p_oty_code => 'LEASE_QUOTE_CONSOLIDATED',
15720: p_source_table => 'OKL_LEASE_QUOTES_B',
15721: p_source_id => p_qte_id,
15722: p_sts_code => 'WORK')
15723: LOOP
15724: l_cfo_exists_at_lq := t_rec.cfo_exists;