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_ASSETS_B

Line 29: okl_assets_b asset

25:
26: cursor adj_csr is
27: SELECT costadj.id
28: FROM okl_cost_adjustments_b costadj,
29: okl_assets_b asset
30: WHERE costadj.adjustment_source_type = 'TRADEIN'
31: AND costadj.parent_object_id = asset.id
32: AND costadj.parent_object_code = 'ASSET'
33: AND asset.parent_object_id = p_quote_id

Line 123: FROM okl_assets_b ast,

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,
124: okl_lease_quotes_b qte
125: WHERE qte.id = ast.parent_object_id
126: AND ast.id= p_quote_id;
127:

Line 330: FROM OKL_ASSETS_B

326: ln_index NUMBER;
327:
328: CURSOR c_get_quote_id(p_asset_id NUMBER) IS
329: SELECT PARENT_OBJECT_ID
330: FROM OKL_ASSETS_B
331: WHERE ID = p_asset_id
332: AND PARENT_OBJECT_CODE='LEASEQUOTE';
333:
334: CURSOR c_get_parent_object_code(p_quote_id NUMBER) IS

Line 612: lv_asset_number okl_assets_b.asset_number%TYPE;

608: lv_parent_code VARCHAR2(30);
609: ln_total_subsidy_amount NUMBER := 0;
610: ln_subsidy_amount NUMBER;
611: ln_subsidy_id NUMBER;
612: lv_asset_number okl_assets_b.asset_number%TYPE;
613: lv_asset_sub_applicable VARCHAR2(1);
614:
615: CURSOR c_get_quote_lop_info IS
616: SELECT quote.expected_start_date,

Line 625: okl_assets_b asset,

621: leaseopp.CUST_ACCT_ID,
622: quote.product_id,
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

Line 647: okl_assets_b asset,

643: leaseapp.CUST_ACCT_ID,
644: quote.product_id,
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

Line 661: FROM okl_assets_b

657: AND quote.parent_object_id = leaseapp.id;
658:
659: CURSOR c_get_asset_number(p_asset_id IN NUMBER) IS
660: SELECT asset_number
661: FROM okl_assets_b
662: WHERE id = p_asset_id;
663:
664: l_input_adj_tbl asset_adj_tbl_type;
665:

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 777: lv_asset_number okl_assets_b.asset_number%TYPE;

773: lv_parent_code VARCHAR2(30);
774: ln_total_subsidy_amount NUMBER := 0;
775: ln_subsidy_amount NUMBER;
776: ln_subsidy_id NUMBER;
777: lv_asset_number okl_assets_b.asset_number%TYPE;
778: lv_asset_sub_applicable VARCHAR2(1);
779:
780: CURSOR c_get_quote_lop_info IS
781: SELECT quote.expected_start_date,

Line 790: okl_assets_b asset,

786: leaseopp.CUST_ACCT_ID,
787: quote.product_id,
788: leaseopp.SALES_REP_ID
789: FROM
790: okl_assets_b asset,
791: okl_asset_components_b assetcomp,
792: okl_lease_quotes_b quote,
793: okl_lease_opportunities_b leaseopp
794: WHERE

Line 812: okl_assets_b asset,

808: leaseapp.CUST_ACCT_ID,
809: quote.product_id,
810: leaseapp.SALES_REP_ID
811: FROM
812: okl_assets_b asset,
813: okl_asset_components_b assetcomp,
814: okl_lease_quotes_b quote,
815: okl_lease_applications_b leaseapp
816: WHERE

Line 826: FROM okl_assets_b

822: AND quote.parent_object_id = leaseapp.id;
823:
824: CURSOR c_get_asset_number(p_asset_id IN NUMBER) IS
825: SELECT asset_number
826: FROM okl_assets_b
827: WHERE id = p_asset_id;
828:
829: l_input_adj_rec okl_cdj_pvt.cdjv_rec_type;
830:

Line 836: FROM okl_assets_b ast, okl_lease_quotes_b lsq

832: l_input_adj_rec := p_input_adj_rec;
833:
834: SELECT lsq.parent_object_code
835: INTO lv_parent_code
836: FROM okl_assets_b ast, okl_lease_quotes_b lsq
837: where ast.parent_object_id = lsq.id
838: and ast.parent_object_code = 'LEASEQUOTE'
839: and ast.id = p_asset_id;
840:

Line 1180: FROM okl_assets_b asset,

1176: AND quote.parent_object_code = 'LEASEAPP';
1177:
1178: CURSOR c_get_inv_items IS
1179: SELECT assetcomp.INV_ITEM_ID
1180: FROM okl_assets_b asset,
1181: okl_asset_components_b assetcomp
1182: WHERE
1183: asset.id = assetcomp.asset_id
1184: AND assetcomp.PRIMARY_COMPONENT = 'YES'

Line 1268: okl_assets_b asset,

1264: leaseopp.CUST_ACCT_ID,
1265: quote.product_id,
1266: leaseopp.SALES_REP_ID
1267: FROM
1268: okl_assets_b asset,
1269: okl_asset_components_b assetcomp,
1270: okl_lease_quotes_b quote,
1271: okl_lease_opportunities_b leaseopp
1272: WHERE

Line 1290: okl_assets_b asset,

1286: leaseapp.CUST_ACCT_ID,
1287: quote.product_id,
1288: leaseapp.SALES_REP_ID
1289: FROM
1290: okl_assets_b asset,
1291: okl_asset_components_b assetcomp,
1292: okl_lease_quotes_b quote,
1293: okl_lease_applications_b leaseapp
1294: WHERE

Line 1305: FROM okl_assets_b ast, okl_lease_quotes_b lsq

1301:
1302: BEGIN
1303: SELECT lsq.parent_object_code
1304: INTO lv_parent_code
1305: FROM okl_assets_b ast, okl_lease_quotes_b lsq
1306: where ast.parent_object_id = lsq.id
1307: and ast.parent_object_code = 'LEASEQUOTE'
1308: and ast.id = p_asset_id;
1309:

Line 1393: from okl_assets_b

1389: from okl_cost_adjustments_v
1390: where parent_object_code = 'ASSET'
1391: and adjustment_source_type in ('DOWN_PAYMENT', 'TRADEIN', 'SUBSIDY')
1392: and parent_object_id IN (select id
1393: from okl_assets_b
1394: where parent_object_id = p_source_quote_id
1395: and parent_object_code = 'LEASEQUOTE');
1396:
1397: BEGIN

Line 1664: okl_assets_b asset

1660:
1661: CURSOR c_db_adj_assets IS
1662: SELECT costadj.id, costadj.parent_object_id
1663: FROM okl_cost_adjustments_b costadj,
1664: okl_assets_b asset
1665: WHERE costadj.adjustment_source_type = p_adj_type
1666: AND costadj.parent_object_id = asset.id
1667: AND costadj.parent_object_code = 'ASSET'
1668: AND asset.parent_object_id = p_quote_id

Line 1674: okl_assets_b asset

1670:
1671: CURSOR c_db_subs_assets(p_adj_source_id IN NUMBER) IS
1672: SELECT costadj.id, costadj.parent_object_id
1673: FROM okl_cost_adjustments_b costadj,
1674: okl_assets_b asset
1675: WHERE costadj.adjustment_source_type = p_adj_type
1676: AND costadj.adjustment_source_id = p_adj_source_id
1677: AND costadj.parent_object_id = asset.id
1678: AND costadj.parent_object_code = 'ASSET'

Line 1870: FROM OKL_ASSETS_B

1866: lx_adjust_tbl cdj_tbl_type;
1867:
1868: CURSOR c_get_new_asset_id (p_source_asset_id IN NUMBER) IS
1869: SELECT id
1870: FROM OKL_ASSETS_B
1871: WHERE ORIG_ASSET_ID = p_source_asset_id
1872: AND PARENT_OBJECT_ID = p_target_quote_id;
1873:
1874: BEGIN

Line 2018: FROM OKL_ASSETS_B

2014:
2015: -- Check if the sum of all Asset OEC percentages greater than '100'
2016: SELECT SUM(OEC_PERCENTAGE)
2017: INTO ln_sum_oec_percentage
2018: FROM OKL_ASSETS_B
2019: WHERE PARENT_OBJECT_ID = p_asset_rec.parent_object_id
2020: AND ID NOT IN (SELECT ID FROM OKL_ASSETS_B WHERE ID = p_asset_rec.id);
2021:
2022: IF (ln_sum_oec_percentage IS NULL) THEN

Line 2020: AND ID NOT IN (SELECT ID FROM OKL_ASSETS_B WHERE ID = p_asset_rec.id);

2016: SELECT SUM(OEC_PERCENTAGE)
2017: INTO ln_sum_oec_percentage
2018: FROM OKL_ASSETS_B
2019: WHERE PARENT_OBJECT_ID = p_asset_rec.parent_object_id
2020: AND ID NOT IN (SELECT ID FROM OKL_ASSETS_B WHERE ID = p_asset_rec.id);
2021:
2022: IF (ln_sum_oec_percentage IS NULL) THEN
2023: ln_sum_oec_percentage := 0;
2024: END IF;

Line 2092: lv_asset_number okl_assets_b.asset_number%TYPE;

2088: lb_validate_subsidy_usage BOOLEAN;
2089:
2090: asset_adj_defined VARCHAR2(1) := 'N';
2091: x_asset_id okl_cost_adjustments_b.adjustment_source_id%type;
2092: lv_asset_number okl_assets_b.asset_number%TYPE;
2093: ln_index NUMBER;
2094:
2095: --Bug 7291307 : Adding starts
2096: cursor get_quote_id_csr(p_asset_id NUMBER) IS

Line 2098: from okl_assets_b

2094:
2095: --Bug 7291307 : Adding starts
2096: cursor get_quote_id_csr(p_asset_id NUMBER) IS
2097: select PARENT_OBJECT_ID
2098: from okl_assets_b
2099: where id=p_asset_id
2100: and parent_object_code='LEASEQUOTE';
2101:
2102: l_cost_adj_desc okl_cost_adjustments_tl.description%TYPE;

Line 2152: FROM okl_assets_b

2148: IF (asset_adj_defined = 'Y') THEN
2149:
2150: SELECT asset_number
2151: INTO lv_asset_number
2152: FROM okl_assets_b
2153: where id = x_asset_id;
2154:
2155: IF (l_asset_adj_tbl(ln_index).adjustment_source_type = 'DOWN_PAYMENT') THEN
2156: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 2277: FROM okl_assets_b ast,okl_lease_quotes_b qte

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

Line 2648: FROM okl_assets_b ast,okl_lease_quotes_b qte

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

Line 2734: okl_assets_b asset

2730:
2731: CURSOR c_db_adj_assets IS
2732: SELECT costadj.id, costadj.adjustment_source_id
2733: FROM okl_cost_adjustments_b costadj,
2734: okl_assets_b asset
2735: WHERE costadj.adjustment_source_type = p_adjustment_type
2736: AND costadj.parent_object_id = asset.id
2737: AND costadj.parent_object_code = 'ASSET'
2738: AND asset.parent_object_id = p_quote_id

Line 2914: AND SOURCE_TABLE='OKL_ASSETS_B';

2910: SELECT ID
2911: FROM OKL_CASH_FLOW_OBJECTS
2912: WHERE SOURCE_ID = p_src_id
2913: AND OTY_CODE = 'QUOTED_ASSET'
2914: AND SOURCE_TABLE='OKL_ASSETS_B';
2915: --Fix Bug # 5021724 ssdeshpa end
2916:
2917: CURSOR c_get_cashflow_info(p_cfo_id OKL_CASH_FLOWS.CFO_ID%TYPE)
2918: IS

Line 3371: okl_assets_b asset,

3367: quote.pricing_method,
3368: quote.end_of_term_option_id
3369: INTO ld_src_start_date, ln_src_pdt_id, lv_src_pricing_type, ln_src_eot_id
3370: FROM
3371: okl_assets_b asset,
3372: okl_lease_quotes_b quote
3373: WHERE
3374: asset.id = p_source_asset_id
3375: AND asset.parent_object_id = quote.id

Line 4046: l_asset_id OKL_ASSETS_B.ID%TYPE;

4042: l_asset_rec asset_rec_type;
4043:
4044: l_return_status VARCHAR2(1);
4045: i BINARY_INTEGER := 0;
4046: l_asset_id OKL_ASSETS_B.ID%TYPE;
4047: l_p_id NUMBER;
4048: l_p_code VARCHAR2(30);
4049:
4050: -- Cursors to check the existence of asset information

Line 4051: CURSOR c_get_asset_components(p_asset_id OKL_ASSETS_B.ID%TYPE)

4047: l_p_id NUMBER;
4048: l_p_code VARCHAR2(30);
4049:
4050: -- Cursors to check the existence of asset information
4051: CURSOR c_get_asset_components(p_asset_id OKL_ASSETS_B.ID%TYPE)
4052: IS
4053: SELECT ID
4054: FROM OKL_ASSET_COMPONENTS_B
4055: WHERE ASSET_ID = p_asset_id;

Line 4057: CURSOR c_get_line_relationships(p_asset_id OKL_ASSETS_B.ID%TYPE)

4053: SELECT ID
4054: FROM OKL_ASSET_COMPONENTS_B
4055: WHERE ASSET_ID = p_asset_id;
4056:
4057: CURSOR c_get_line_relationships(p_asset_id OKL_ASSETS_B.ID%TYPE)
4058: IS
4059: SELECT ID
4060: FROM OKL_LINE_RELATIONSHIPS_B
4061: WHERE SOURCE_LINE_ID = p_asset_id;

Line 4134: okl_assets_b ast

4130:
4131: /*SELECT qte.parent_object_id,qte.parent_object_code
4132: INTO l_p_id,l_p_code
4133: FROM okl_lease_quotes_b qte,
4134: okl_assets_b ast
4135: WHERE ast.parent_object_id = qte.id
4136: AND ast.ID = l_asset_id;
4137:
4138: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(

Line 4232: CURSOR c_check_cash_flow(p_asset_id OKL_ASSETS_B.ID%TYPE)

4228:
4229: l_p_id NUMBER;
4230: l_p_code VARCHAR2(30);
4231:
4232: CURSOR c_check_cash_flow(p_asset_id OKL_ASSETS_B.ID%TYPE)
4233: IS
4234: SELECT 'YES'
4235: FROM OKL_CASH_FLOW_OBJECTS
4236: WHERE OTY_CODE = 'QUOTED_ASSET'

Line 4237: AND SOURCE_TABLE = 'OKL_ASSETS_B'

4233: IS
4234: SELECT 'YES'
4235: FROM OKL_CASH_FLOW_OBJECTS
4236: WHERE OTY_CODE = 'QUOTED_ASSET'
4237: AND SOURCE_TABLE = 'OKL_ASSETS_B'
4238: AND SOURCE_ID = p_asset_id;
4239:
4240: BEGIN
4241: