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

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

Line 794: okl_assets_b asset,

790: leaseopp.CUST_ACCT_ID,
791: quote.product_id,
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

Line 816: okl_assets_b asset,

812: leaseapp.CUST_ACCT_ID,
813: quote.product_id,
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

Line 830: FROM okl_assets_b

826: AND quote.parent_object_id = leaseapp.id;
827:
828: CURSOR c_get_asset_number(p_asset_id IN NUMBER) IS
829: SELECT asset_number
830: FROM okl_assets_b
831: WHERE id = p_asset_id;
832:
833: l_input_adj_rec okl_cdj_pvt.cdjv_rec_type;
834:

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 1184: FROM okl_assets_b asset,

1180: AND quote.parent_object_code = 'LEASEAPP';
1181:
1182: CURSOR c_get_inv_items IS
1183: SELECT assetcomp.INV_ITEM_ID
1184: FROM okl_assets_b asset,
1185: okl_asset_components_b assetcomp
1186: WHERE
1187: asset.id = assetcomp.asset_id
1188: AND assetcomp.PRIMARY_COMPONENT = 'YES'

Line 1272: okl_assets_b asset,

1268: leaseopp.CUST_ACCT_ID,
1269: quote.product_id,
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

Line 1294: okl_assets_b asset,

1290: leaseapp.CUST_ACCT_ID,
1291: quote.product_id,
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

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 1397: from okl_assets_b

1393: from okl_cost_adjustments_v
1394: where parent_object_code = 'ASSET'
1395: and adjustment_source_type in ('DOWN_PAYMENT', 'TRADEIN', 'SUBSIDY')
1396: and parent_object_id IN (select id
1397: from okl_assets_b
1398: where parent_object_id = p_source_quote_id
1399: and parent_object_code = 'LEASEQUOTE');
1400:
1401: BEGIN

Line 1668: okl_assets_b asset

1664:
1665: CURSOR c_db_adj_assets IS
1666: SELECT costadj.id, costadj.parent_object_id
1667: FROM okl_cost_adjustments_b costadj,
1668: okl_assets_b asset
1669: WHERE costadj.adjustment_source_type = p_adj_type
1670: AND costadj.parent_object_id = asset.id
1671: AND costadj.parent_object_code = 'ASSET'
1672: AND asset.parent_object_id = p_quote_id

Line 1678: okl_assets_b asset

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

Line 1874: FROM OKL_ASSETS_B

1870: lx_adjust_tbl cdj_tbl_type;
1871:
1872: CURSOR c_get_new_asset_id (p_source_asset_id IN NUMBER) IS
1873: SELECT id
1874: FROM OKL_ASSETS_B
1875: WHERE ORIG_ASSET_ID = p_source_asset_id
1876: AND PARENT_OBJECT_ID = p_target_quote_id;
1877:
1878: BEGIN

Line 2022: FROM OKL_ASSETS_B

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

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

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

Line 2096: lv_asset_number okl_assets_b.asset_number%TYPE;

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

Line 2102: from okl_assets_b

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

Line 2156: FROM okl_assets_b

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

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 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 2738: okl_assets_b asset

2734:
2735: CURSOR c_db_adj_assets IS
2736: SELECT costadj.id, costadj.adjustment_source_id
2737: FROM okl_cost_adjustments_b costadj,
2738: okl_assets_b asset
2739: WHERE costadj.adjustment_source_type = p_adjustment_type
2740: AND costadj.parent_object_id = asset.id
2741: AND costadj.parent_object_code = 'ASSET'
2742: AND asset.parent_object_id = p_quote_id

Line 2918: AND SOURCE_TABLE='OKL_ASSETS_B';

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

Line 3375: okl_assets_b asset,

3371: quote.pricing_method,
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

Line 4050: l_asset_id OKL_ASSETS_B.ID%TYPE;

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

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

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

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

4057: SELECT ID
4058: FROM OKL_ASSET_COMPONENTS_B
4059: WHERE ASSET_ID = p_asset_id;
4060:
4061: CURSOR c_get_line_relationships(p_asset_id OKL_ASSETS_B.ID%TYPE)
4062: IS
4063: SELECT ID
4064: FROM OKL_LINE_RELATIONSHIPS_B
4065: WHERE SOURCE_LINE_ID = p_asset_id;

Line 4138: okl_assets_b ast

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:
4142: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(

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

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

Line 4241: AND SOURCE_TABLE = 'OKL_ASSETS_B'

4237: IS
4238: SELECT 'YES'
4239: FROM OKL_CASH_FLOW_OBJECTS
4240: WHERE OTY_CODE = 'QUOTED_ASSET'
4241: AND SOURCE_TABLE = 'OKL_ASSETS_B'
4242: AND SOURCE_ID = p_asset_id;
4243:
4244: BEGIN
4245: