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_LEASE_QUOTE_ASSET_PVT dependencies on OKL_LEASE_QUOTES_B

Line 119: lv_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;

115: l_start_date DATE;
116: l_cf_hdr_rec cashflow_hdr_rec_type;
117: l_cashflow_level_tbl cashflow_level_tbl_type;
118: l_adj_assets_rec okl_cdj_pvt.cdjv_rec_type;
119: lv_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;
120:
121: CURSOR get_quote_rec(p_quote_id NUMBER) IS
122: SELECT qte.id, qte.expected_start_date, qte.parent_object_code
123: FROM okl_assets_b ast,

Line 124: okl_lease_quotes_b qte

120:
121: CURSOR get_quote_rec(p_quote_id NUMBER) IS
122: SELECT qte.id, qte.expected_start_date, qte.parent_object_code
123: FROM okl_assets_b ast,
124: okl_lease_quotes_b qte
125: WHERE qte.id = ast.parent_object_id
126: AND ast.id= p_quote_id;
127:
128: BEGIN

Line 288: from okl_lease_quotes_b

284: lv_target_pricing_type VARCHAR2(15);
285: BEGIN
286: select pricing_method
287: into lv_source_pricing_type
288: from okl_lease_quotes_b
289: where id = p_source_quote_id;
290:
291: select pricing_method
292: into lv_target_pricing_type

Line 293: from okl_lease_quotes_b

289: where id = p_source_quote_id;
290:
291: select pricing_method
292: into lv_target_pricing_type
293: from okl_lease_quotes_b
294: where id = p_target_quote_id;
295:
296: IF (lv_source_pricing_type = lv_target_pricing_type) THEN
297: RETURN 'Y';

Line 323: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

319: l_compare_amt NUMBER;
320: l_diff NUMBER;
321: l_adj_rec BINARY_INTEGER;
322: lx_return_status VARCHAR2(1);
323: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
324: l_quote_id NUMBER;
325:
326: ln_index NUMBER;
327:

Line 336: FROM okl_lease_quotes_b

332: AND PARENT_OBJECT_CODE='LEASEQUOTE';
333:
334: CURSOR c_get_parent_object_code(p_quote_id NUMBER) IS
335: SELECT parent_object_code
336: FROM okl_lease_quotes_b
337: WHERE id = p_quote_id;
338: BEGIN
339:
340: l_assoc_total := 0;

Line 360: okl_lease_quotes_b lsq

356: IF (lv_parent_object_code = 'LEASEOPP') THEN
357: SELECT currency_code
358: INTO l_currency_code
359: FROM okl_lease_opportunities_b lop,
360: okl_lease_quotes_b lsq
361: WHERE lsq.parent_object_code = lv_parent_object_code
362: AND lsq.parent_object_id = lop.id
363: AND lsq.id = l_quote_id;
364: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN

Line 368: okl_lease_quotes_b lsq

364: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN
365: SELECT currency_code
366: INTO l_currency_code
367: FROM okl_lease_applications_b lap,
368: okl_lease_quotes_b lsq
369: WHERE lsq.parent_object_code = lv_parent_object_code
370: AND lsq.parent_object_id = lap.id
371: AND lsq.id = l_quote_id;
372: END IF;

Line 494: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

490: l_compare_amt NUMBER;
491: l_diff NUMBER;
492: l_adj_rec BINARY_INTEGER;
493: lx_return_status VARCHAR2(1);
494: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
495: l_quote_id NUMBER;
496: ln_index NUMBER;
497:
498: BEGIN

Line 627: okl_lease_quotes_b quote,

623: leaseopp.SALES_REP_ID
624: FROM
625: okl_assets_b asset,
626: okl_asset_components_b assetcomp,
627: okl_lease_quotes_b quote,
628: okl_lease_opportunities_b leaseopp
629: WHERE
630: asset.id = p_asset_id
631: AND asset.id = assetcomp.asset_id

Line 649: okl_lease_quotes_b quote,

645: leaseapp.SALES_REP_ID
646: FROM
647: okl_assets_b asset,
648: okl_asset_components_b assetcomp,
649: okl_lease_quotes_b quote,
650: okl_lease_applications_b leaseapp
651: WHERE
652: asset.id = p_asset_id
653: AND asset.id = assetcomp.asset_id

Line 671: FROM okl_assets_b ast, okl_lease_quotes_b lsq

667: l_input_adj_tbl := p_input_adj_tbl;
668:
669: SELECT lsq.parent_object_code
670: INTO lv_parent_code
671: FROM okl_assets_b ast, okl_lease_quotes_b lsq
672: where ast.parent_object_id = lsq.id
673: and ast.parent_object_code = 'LEASEQUOTE'
674: and ast.id = p_asset_id;
675:

Line 796: okl_lease_quotes_b quote,

792: leaseopp.SALES_REP_ID
793: FROM
794: okl_assets_b asset,
795: okl_asset_components_b assetcomp,
796: okl_lease_quotes_b quote,
797: okl_lease_opportunities_b leaseopp
798: WHERE
799: asset.id = p_asset_id
800: AND asset.id = assetcomp.asset_id

Line 818: okl_lease_quotes_b quote,

814: leaseapp.SALES_REP_ID
815: FROM
816: okl_assets_b asset,
817: okl_asset_components_b assetcomp,
818: okl_lease_quotes_b quote,
819: okl_lease_applications_b leaseapp
820: WHERE
821: asset.id = p_asset_id
822: AND asset.id = assetcomp.asset_id

Line 840: FROM okl_assets_b ast, okl_lease_quotes_b lsq

836: l_input_adj_rec := p_input_adj_rec;
837:
838: SELECT lsq.parent_object_code
839: INTO lv_parent_code
840: FROM okl_assets_b ast, okl_lease_quotes_b lsq
841: where ast.parent_object_id = lsq.id
842: and ast.parent_object_code = 'LEASEQUOTE'
843: and ast.id = p_asset_id;
844:

Line 1086: OKL_LEASE_QUOTES_B QTE

1082: SELECT
1083: EOT.EOT_TYPE_CODE
1084: FROM OKL_FE_EO_TERMS_ALL_B EOT,
1085: OKL_FE_EO_TERM_VERS EOT_VER,
1086: OKL_LEASE_QUOTES_B QTE
1087: WHERE
1088: EOT_VER.END_OF_TERM_VER_ID = QTE.END_OF_TERM_OPTION_ID
1089: AND EOT_VER.END_OF_TERM_ID = EOT.END_OF_TERM_ID
1090: AND QTE.ID = p_quote_id;

Line 1159: okl_lease_quotes_b quote,

1155: leaseopp.CUST_ACCT_ID,
1156: quote.product_id,
1157: leaseopp.SALES_REP_ID
1158: FROM
1159: okl_lease_quotes_b quote,
1160: okl_lease_opportunities_b leaseopp
1161: WHERE
1162: quote.id = p_quote_id
1163: AND quote.parent_object_id = leaseopp.id

Line 1175: okl_lease_quotes_b quote,

1171: leaseapp.CUST_ACCT_ID,
1172: quote.product_id,
1173: leaseapp.SALES_REP_ID
1174: FROM
1175: okl_lease_quotes_b quote,
1176: okl_lease_applications_b leaseapp
1177: WHERE
1178: quote.id = p_quote_id
1179: AND quote.parent_object_id = leaseapp.id

Line 1195: FROM okl_lease_quotes_b

1191:
1192: BEGIN
1193: SELECT parent_object_code
1194: INTO lv_parent_code
1195: FROM okl_lease_quotes_b
1196: where id = p_quote_id;
1197:
1198: IF (lv_parent_code = 'LEASEOPP') THEN
1199: OPEN c_get_quote_lop_info;

Line 1274: okl_lease_quotes_b quote,

1270: leaseopp.SALES_REP_ID
1271: FROM
1272: okl_assets_b asset,
1273: okl_asset_components_b assetcomp,
1274: okl_lease_quotes_b quote,
1275: okl_lease_opportunities_b leaseopp
1276: WHERE
1277: asset.id = p_asset_id
1278: AND asset.id = assetcomp.asset_id

Line 1296: okl_lease_quotes_b quote,

1292: leaseapp.SALES_REP_ID
1293: FROM
1294: okl_assets_b asset,
1295: okl_asset_components_b assetcomp,
1296: okl_lease_quotes_b quote,
1297: okl_lease_applications_b leaseapp
1298: WHERE
1299: asset.id = p_asset_id
1300: AND asset.id = assetcomp.asset_id

Line 1309: FROM okl_assets_b ast, okl_lease_quotes_b lsq

1305:
1306: BEGIN
1307: SELECT lsq.parent_object_code
1308: INTO lv_parent_code
1309: FROM okl_assets_b ast, okl_lease_quotes_b lsq
1310: where ast.parent_object_id = lsq.id
1311: and ast.parent_object_code = 'LEASEQUOTE'
1312: and ast.id = p_asset_id;
1313:

Line 1782: FROM okl_lease_quotes_b

1778: lv_parent_object_code VARCHAR2(30);
1779:
1780: CURSOR c_get_parent_object_code(parent_object_id NUMBER) IS
1781: SELECT parent_object_code
1782: FROM okl_lease_quotes_b
1783: WHERE id = p_asset_rec.parent_object_id;
1784:
1785: BEGIN
1786:

Line 1813: okl_lease_quotes_b lsq

1809: IF (lv_parent_object_code = 'LEASEOPP') THEN
1810: SELECT currency_code
1811: INTO l_currency_code
1812: FROM okl_lease_opportunities_b lop,
1813: okl_lease_quotes_b lsq
1814: WHERE lsq.parent_object_code = lv_parent_object_code
1815: AND lsq.parent_object_id = lop.id
1816: AND lsq.id = p_asset_rec.parent_object_id;
1817: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN

Line 1821: okl_lease_quotes_b lsq

1817: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN
1818: SELECT currency_code
1819: INTO l_currency_code
1820: FROM okl_lease_applications_b lap,
1821: okl_lease_quotes_b lsq
1822: WHERE lsq.parent_object_code = lv_parent_object_code
1823: AND lsq.parent_object_id = lap.id
1824: AND lsq.id = p_asset_rec.parent_object_id;
1825: END IF;

Line 1986: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

1982:
1983: l_program_name CONSTANT VARCHAR2(30) := 'validate';
1984: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1985:
1986: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
1987: ln_check_pec_percentage NUMBER;
1988: ln_sum_oec_percentage NUMBER;
1989:
1990: BEGIN

Line 2005: FROM OKL_LEASE_QUOTES_B

2001: -- Validate Asset percentage in case of 'Solve for Financed Amount'
2002: -- pricng method scenario
2003: SELECT PRICING_METHOD
2004: INTO lv_pricing_method
2005: FROM OKL_LEASE_QUOTES_B
2006: WHERE ID = p_asset_rec.parent_object_id;
2007:
2008: IF (lv_pricing_method = 'SF') THEN
2009:

Line 2108: l_quote_id okl_lease_quotes_b.id%TYPE;

2104: and parent_object_code='LEASEQUOTE';
2105:
2106: l_cost_adj_desc okl_cost_adjustments_tl.description%TYPE;
2107: l_sync_desc VARCHAR2(1):='N';
2108: l_quote_id okl_lease_quotes_b.id%TYPE;
2109: --Bug 7291307 : Adding end
2110:
2111: BEGIN
2112: IF p_transaction_control = G_TRUE THEN

Line 2281: FROM okl_assets_b ast,okl_lease_quotes_b qte

2277: --Bug # 5142940 ssdeshpa end
2278:
2279: /*SELECT qte.parent_object_id,qte.parent_object_code
2280: INTO l_p_id,l_p_code
2281: FROM okl_assets_b ast,okl_lease_quotes_b qte
2282: WHERE qte.id = ast.parent_object_id
2283: AND ast.id= l_asset_adj_tbl(1).parent_object_id;
2284:
2285:

Line 2388: l_quote_id okl_lease_quotes_b.id%TYPE;

2384: ln_index NUMBER;
2385: --Bug 7291307 : Adding start
2386: l_cost_adj_desc okl_cost_adjustments_tl.description%TYPE;
2387: l_sync_desc VARCHAR2(1):='N';
2388: l_quote_id okl_lease_quotes_b.id%TYPE;
2389: --Bug 7291307 : Adding end
2390:
2391: BEGIN
2392: IF p_transaction_control = G_TRUE THEN

Line 2652: FROM okl_assets_b ast,okl_lease_quotes_b qte

2648: END IF;
2649:
2650: /*SELECT qte.parent_object_id,qte.parent_object_code
2651: INTO l_p_id,l_p_code
2652: FROM okl_assets_b ast,okl_lease_quotes_b qte
2653: WHERE qte.id = ast.parent_object_id
2654: AND ast.id= l_asset_adj_tbl(1).parent_object_id;
2655:
2656:

Line 2822: FROM okl_lease_quotes_b where ID = p_quote_id;

2818: --Bug # 5142940 ssdeshpa start
2819: END IF;
2820:
2821: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
2822: FROM okl_lease_quotes_b where ID = p_quote_id;
2823:
2824: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(
2825: p_api_version => G_API_VERSION
2826: ,p_init_msg_list => G_FALSE

Line 2967: FROM okl_lease_quotes_b

2963: END IF;
2964:
2965: SELECT parent_object_code
2966: INTO lv_parent_object_code
2967: FROM okl_lease_quotes_b
2968: where id = p_quote_id;
2969:
2970: IF (lv_parent_object_code = 'LEASEOPP') THEN
2971: l_cashflow_header_rec.quote_type_code := 'LQ';

Line 3353: l_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;

3349: ln_src_pdt_id NUMBER;
3350: ln_tgt_pdt_id NUMBER;
3351: lv_src_pricing_type VARCHAR2(30);
3352: lv_tgt_pricing_type VARCHAR2(30);
3353: l_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;
3354: ln_src_eot_id NUMBER;
3355: ln_tgt_eot_id NUMBER;
3356:
3357: BEGIN

Line 3376: okl_lease_quotes_b quote

3372: quote.end_of_term_option_id
3373: INTO ld_src_start_date, ln_src_pdt_id, lv_src_pricing_type, ln_src_eot_id
3374: FROM
3375: okl_assets_b asset,
3376: okl_lease_quotes_b quote
3377: WHERE
3378: asset.id = p_source_asset_id
3379: AND asset.parent_object_id = quote.id
3380: AND asset.parent_object_code = 'LEASEQUOTE';

Line 3389: okl_lease_quotes_b

3385: parent_object_code,
3386: end_of_term_option_id
3387: INTO ld_tgt_start_date, ln_tgt_pdt_id, lv_tgt_pricing_type,l_parent_object_code, ln_tgt_eot_id
3388: FROM
3389: okl_lease_quotes_b
3390: WHERE
3391: id = p_target_quote_id;
3392:
3393: IF ((ld_src_start_date <> ld_tgt_start_date) OR (ln_src_pdt_id <> ln_tgt_pdt_id)) THEN

Line 3968: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;

3964: END IF;
3965: END IF;
3966:
3967: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
3968: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;
3969:
3970: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(
3971: p_api_version => G_API_VERSION
3972: ,p_init_msg_list => G_FALSE

Line 4137: FROM okl_lease_quotes_b qte,

4133: -- End
4134:
4135: /*SELECT qte.parent_object_id,qte.parent_object_code
4136: INTO l_p_id,l_p_code
4137: FROM okl_lease_quotes_b qte,
4138: okl_assets_b ast
4139: WHERE ast.parent_object_id = qte.id
4140: AND ast.ID = l_asset_id;
4141:

Line 4520: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;

4516: END IF;
4517: END IF;
4518:
4519: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
4520: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;
4521:
4522: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(
4523: p_api_version => G_API_VERSION
4524: ,p_init_msg_list => G_FALSE

Line 4613: CURSOR c_get_supplier_id(p_qte_id IN OKL_LEASE_QUOTES_B.ID%TYPE) IS

4609:
4610: l_return_status VARCHAR2(1);
4611: ln_index NUMBER;
4612:
4613: CURSOR c_get_supplier_id(p_qte_id IN OKL_LEASE_QUOTES_B.ID%TYPE) IS
4614: SELECT LOP.SUPPLIER_ID supplier_id
4615: FROM OKL_LEASE_OPPORTUNITIES_B LOP,
4616: OKL_LEASE_QUOTES_B QTE
4617: WHERE LOP.ID = QTE.parent_object_id

Line 4616: OKL_LEASE_QUOTES_B QTE

4612:
4613: CURSOR c_get_supplier_id(p_qte_id IN OKL_LEASE_QUOTES_B.ID%TYPE) IS
4614: SELECT LOP.SUPPLIER_ID supplier_id
4615: FROM OKL_LEASE_OPPORTUNITIES_B LOP,
4616: OKL_LEASE_QUOTES_B QTE
4617: WHERE LOP.ID = QTE.parent_object_id
4618: AND qte.id = p_qte_id;
4619:
4620: BEGIN