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_SALES_QUOTE_QA_PVT dependencies on OKL_ASSETS_B

Line 197: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB

193:
194: --Added Cursors to get Deal Size of LQ
195: CURSOR c_deal_size_cur(p_parent_object_id NUMBER) IS
196: select SUM(OEC)
197: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
198: where OAB.PARENT_OBJECT_ID = OLQ.ID
199: AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
200: AND OLQ.ID= p_parent_object_id;
201: --Added Cursors to get Adjustment(DN,Trade In Subsidy) for LQ

Line 205: OKL_ASSETS_B OAB

201: --Added Cursors to get Adjustment(DN,Trade In Subsidy) for LQ
202: cursor c_lq_cost_adj_rec(p_quote_id NUMBER,p_adj_type VARCHAR2) IS
203: SELECT SUM(VALUE)
204: FROM OKL_COST_ADJUSTMENTS_B OCA,
205: OKL_ASSETS_B OAB
206: where OAB.PARENT_OBJECT_CODE = 'LEASEQUOTE'
207: AND OCA.PARENT_OBJECT_CODE='ASSET'
208: AND OCA.PARENT_OBJECT_ID=OAB.ID
209: and ADJUSTMENT_SOURCE_TYPE =p_adj_type

Line 215: OKL_ASSETS_B OAB

211: --Addes cursor to get Item For LQ
212: CURSOR c_cost_comp_cur(p_quote_id NUMBER) IS
213: select OAC.INV_ITEM_ID
214: from OKL_ASSET_COMPONENTS_B OAC,
215: OKL_ASSETS_B OAB
216: WHERE OAC.ASSET_ID = OAB.ID
217: AND OAB.PARENT_OBJECT_CODE = 'LEASEQUOTE'
218: AND PRIMARY_COMPONENT='YES'
219: AND OAB.PARENT_OBJECT_ID = p_quote_id;

Line 948: OKL_ASSETS_B AST

944: l_ast_cnt NUMBER;
945: CURSOR llo_flag_csr IS
946: SELECT count(*) overriden_assets_count
947: FROM OKL_LEASE_QUOTES_B QTE,
948: OKL_ASSETS_B AST
949: WHERE AST.PARENT_OBJECT_ID = QTE.ID
950: AND ( AST.RATE_TEMPLATE_ID IS NOT NULL
951: OR AST.STRUCTURED_PRICING = 'Y' )
952: AND QTE.ID = p_quote_id

Line 958: OKL_ASSETS_B AST

954:
955: CURSOR rc_llo_flag_csr IS
956: SELECT count(*) overriden_assets_count
957: FROM OKL_LEASE_QUOTES_B QTE,
958: OKL_ASSETS_B AST
959: WHERE AST.PARENT_OBJECT_ID = QTE.ID
960: AND ( AST.RATE_CARD_ID IS NOT NULL
961: OR AST.LEASE_RATE_FACTOR IS NOT NULL )
962: AND QTE.ID = p_quote_id

Line 968: OKL_ASSETS_B AST

964:
965: CURSOR sy_llo_flag_csr IS
966: SELECT count(*) overriden_assets_count
967: FROM OKL_LEASE_QUOTES_B QTE,
968: OKL_ASSETS_B AST
969: WHERE AST.PARENT_OBJECT_ID = QTE.ID
970: AND ( AST.STRUCTURED_PRICING = 'Y')
971: AND QTE.ID = p_quote_id
972: AND p_line_level_pricing = 'Y';

Line 977: OKL_ASSETS_B AST

973:
974: CURSOR ast_cnt_csr IS
975: SELECT count(*) assets_count
976: FROM OKL_LEASE_QUOTES_B QTE,
977: OKL_ASSETS_B AST
978: WHERE AST.PARENT_OBJECT_ID = QTE.ID
979: AND QTE.ID = p_quote_id;
980:
981: BEGIN

Line 1076: FROM OKL_COST_ADJUSTMENTS_B OCA,OKL_ASSETS_B OAB

1072: --Fetch Cost Adj For a Quote
1073: CURSOR c_okl_cost_adj_rec(p_quote_id NUMBER,
1074: p_adj_source_type VARCHAR2) IS
1075: SELECT OCA.id,OCA.adjustment_source_id
1076: FROM OKL_COST_ADJUSTMENTS_B OCA,OKL_ASSETS_B OAB
1077: WHERE OCA.PARENT_OBJECT_CODE = 'ASSET'
1078: AND OCA.PARENT_OBJECT_ID = OAB.ID
1079: AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
1080: AND OAB.PARENT_OBJECT_ID = p_quote_id

Line 1457: from OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB

1453: is_debug_statement_on boolean;
1454: cursor c_lq_asset_lines_rec(p_lease_quote_id NUMBER) IS
1455: --select SUM(NVL(OEC_PERCENTAGE,0))
1456: select oec_percentage
1457: from OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
1458: WHERE OLQ.PRICING_METHOD= 'SF'
1459: AND OAB.parent_object_code='LEASEQUOTE'
1460: AND OAB.parent_object_id = OLQ.id
1461: AND OLQ.id= p_lease_quote_id;

Line 1465: from okl_assets_b oab,

1461: AND OLQ.id= p_lease_quote_id;
1462: --Fix Bug # 4898499 Start
1463: cursor c_lq_asset_comp_rec(p_lease_quote_id NUMBER) IS
1464: select oac.unit_cost
1465: from okl_assets_b oab,
1466: okl_asset_components_b oac
1467: where oab.parent_object_code='LEASEQUOTE'
1468: AND oab.id=oac.asset_id
1469: AND oac.primary_component='YES'

Line 1809: from okl_assets_b oab

1805: select oab.id,
1806: oab.rate_card_id,
1807: oab.rate_template_id,
1808: 'QUOTED_ASSET' oty_code
1809: from okl_assets_b oab
1810: where oab.parent_object_code='LEASEQUOTE'
1811: AND oab.parent_object_id=p_quote_id;
1812:
1813: --Cursor to fetch LRS Name

Line 2227: FROM OKL_ASSETS_B t2

2223: AND PARENT_OBJECT_ID=p_asset_id;
2224:
2225: cursor c_lq_asset_lines_rec(p_quote_id NUMBER) IS
2226: SELECT t2.id,t2.oec
2227: FROM OKL_ASSETS_B t2
2228: where t2.parent_object_code='LEASEQUOTE'
2229: and t2.parent_object_id=p_quote_id;
2230:
2231: BEGIN

Line 2354: SELECT * from okl_assets_b

2350: l_program_name CONSTANT VARCHAR2(30) := 'ext_val';
2351: l_api_name CONSTANT VARCHAR2(61) := l_program_name;
2352:
2353: CURSOR c_lq_asset_rec(p_quote_id NUMBER) IS
2354: SELECT * from okl_assets_b
2355: where PARENT_OBJECT_CODE='LEASEQUOTE'
2356: AND PARENT_OBJECT_ID=p_quote_id;
2357:
2358: CURSOR c_qq_lines_rec(p_quote_id NUMBER) IS

Line 2663: FROM OKL_LEASE_QUOTES_B t1,OKL_ASSETS_B t2

2659: lp_qq_asset_lines_rec c_qq_asset_lines_rec%ROWTYPE;
2660:
2661: cursor c_lq_asset_lines_rec(p_quote_id NUMBER) IS
2662: SELECT t2.*
2663: FROM OKL_LEASE_QUOTES_B t1,OKL_ASSETS_B t2
2664: where t1.id=p_quote_id
2665: AND t1.pricing_method='SF'
2666: and t2.parent_object_code='LEASEQUOTE'
2667: and t2.parent_object_id=t1.id;

Line 2831: FROM OKL_ASSETS_B OLA

2827: -- bug 5048183 ssdeshpa Start
2828: -- Get all the Info abt the Assets for Quote
2829: CURSOR c_lq_asset_rec(p_quote_id NUMBER) IS
2830: SELECT ID,END_OF_TERM_VALUE_DEFAULT,END_OF_TERM_VALUE
2831: FROM OKL_ASSETS_B OLA
2832: WHERE OLA.PARENT_OBJECT_ID=p_quote_id
2833: AND OLA.PARENT_OBJECT_CODE='LEASEQUOTE';
2834: -- bug 5048183 ssdeshpa End
2835: --Fetch Quick Quote Item categories

Line 3290: from okl_assets_b oab

3286: oab.lease_rate_factor,
3287: 'QUOTED_ASSET' oty_code,
3288: oab.target_arrears,
3289: oab.target_amount
3290: from okl_assets_b oab
3291: where oab.parent_object_code='LEASEQUOTE'
3292: AND oab.parent_object_id=p_quote_id;
3293:
3294: -----------------------------

Line 3313: from okl_assets_b oab

3309: oab.rate_template_id,
3310: oab.structured_pricing,
3311: oab.lease_rate_factor,
3312: 'QUOTED_ASSET' oty_code
3313: from okl_assets_b oab
3314: where oab.parent_object_code='LEASEQUOTE'
3315: AND oab.parent_object_id=p_quote_id;
3316:
3317: CURSOR c_payment_level_rec(p_quote_id NUMBER) IS