APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_QUICK_QUOTE_LINES_B

Line 1473: select t2.* from OKL_QUICK_QUOTES_B t1,OKL_QUICK_QUOTE_LINES_B t2

1469: AND oac.primary_component='YES'
1470: AND oab.parent_object_id=p_lease_quote_id;
1471: --Fix Bug # 4898499 End
1472: cursor c_qq_asset_lines_rec(p_quick_quote_id NUMBER,p_pricing_method VARCHAR2,p_type VARCHAR2) IS
1473: select t2.* from OKL_QUICK_QUOTES_B t1,OKL_QUICK_QUOTE_LINES_B t2
1474: WHERE t1.PRICING_METHOD=p_pricing_method
1475: AND t2.type=p_type
1476: AND t1.id=p_quick_quote_id
1477: AND t2.quick_quote_id=t1.id;

Line 1675: FROM OKL_QUICK_QUOTE_LINES_B

1671: lp_line_amt NUMBER;
1672:
1673: cursor c_qq_assets_cost(p_quick_quote_id NUMBER) IS
1674: select ITEM_CATEGORY_ID
1675: FROM OKL_QUICK_QUOTE_LINES_B
1676: WHERE type='ITEM_CATEGORY'
1677: AND quick_quote_id=p_quick_quote_id;
1678:
1679: cursor c_payment_lines_types(p_quick_quote_id NUMBER,p_payment_type VARCHAR2) IS

Line 1681: from OKL_QUICK_QUOTE_LINES_B t2

1677: AND quick_quote_id=p_quick_quote_id;
1678:
1679: cursor c_payment_lines_types(p_quick_quote_id NUMBER,p_payment_type VARCHAR2) IS
1680: select t2.value
1681: from OKL_QUICK_QUOTE_LINES_B t2
1682: WHERE t2.type = p_payment_type
1683: and t2.QUICK_QUOTE_ID = p_quick_quote_id;
1684:
1685: BEGIN

Line 1790: FROM OKL_QUICK_QUOTE_LINES_B

1786: lp_qq_header_rec c_qq_header_rec%ROWTYPE;
1787:
1788: cursor c_qq_assets_cost(p_quick_quote_id NUMBER) IS
1789: select ITEM_CATEGORY_ID
1790: FROM OKL_QUICK_QUOTE_LINES_B
1791: WHERE type='ITEM_CATEGORY'
1792: AND quick_quote_id=p_quick_quote_id;
1793:
1794: --Bug # 5050143 ssdeshpa start

Line 2201: FROM OKL_QUICK_QUOTE_LINES_B

2197: lp_qq_header_rec c_qq_header_rec%ROWTYPE;
2198:
2199: cursor c_qq_assets_cost(p_quick_quote_id NUMBER) IS
2200: SELECT SUM(NVL(VALUE,0))
2201: FROM OKL_QUICK_QUOTE_LINES_B
2202: WHERE type='ITEM_CATEGORY'
2203: AND quick_quote_id=p_quick_quote_id;
2204:
2205: cursor c_qq_cost_adj_total_rec1(p_quick_quote_id NUMBER) IS

Line 2207: from OKL_QUICK_QUOTE_LINES_B t2

2203: AND quick_quote_id=p_quick_quote_id;
2204:
2205: cursor c_qq_cost_adj_total_rec1(p_quick_quote_id NUMBER) IS
2206: select SUM(NVL(VALUE,0))
2207: from OKL_QUICK_QUOTE_LINES_B t2
2208: WHERE t2.type IN('DOWN_PAYMENT','TRADEIN','SUBSIDY')
2209: and t2.basis = 'FIXED'
2210: and t2.QUICK_QUOTE_ID=p_quick_quote_id;
2211:

Line 2214: from OKL_QUICK_QUOTE_LINES_B t2

2210: and t2.QUICK_QUOTE_ID=p_quick_quote_id;
2211:
2212: cursor c_qq_cost_adj_total_rec2(p_quick_quote_id NUMBER) IS
2213: select SUM(NVL(VALUE,0))
2214: from OKL_QUICK_QUOTE_LINES_B t2
2215: WHERE t2.type IN('DOWN_PAYMENT','TRADEIN','SUBSIDY')
2216: and t2.basis = 'ASSET_COST'
2217: and t2.QUICK_QUOTE_ID=p_quick_quote_id;
2218:

Line 2360: from OKL_QUICK_QUOTE_LINES_b t2

2356: AND PARENT_OBJECT_ID=p_quote_id;
2357:
2358: CURSOR c_qq_lines_rec(p_quote_id NUMBER) IS
2359: select t2.*
2360: from OKL_QUICK_QUOTE_LINES_b t2
2361: WHERE t2.quick_quote_id=p_quote_id
2362: AND t2.type='ITEM_CATEGORY';
2363: --Define Local Rec variables
2364: lp_qq_header_rec c_qq_header_rec%ROWTYPE;

Line 2653: select t2.* from OKL_QUICK_QUOTES_B t1,OKL_QUICK_QUOTE_LINES_B t2

2649: l_program_name CONSTANT VARCHAR2(30) := 'chk_ss';
2650: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2651:
2652: cursor c_qq_asset_lines_rec(p_quick_quote_id NUMBER) IS
2653: select t2.* from OKL_QUICK_QUOTES_B t1,OKL_QUICK_QUOTE_LINES_B t2
2654: WHERE t1.PRICING_METHOD='SF'
2655: AND t2.type='SUBSIDY'
2656: AND t1.id=p_quick_quote_id
2657: AND t2.quick_quote_id=t1.id;

Line 2838: FROM OKL_QUICK_QUOTE_LINES_B OAL

2834: -- bug 5048183 ssdeshpa End
2835: --Fetch Quick Quote Item categories
2836: CURSOR c_qq_asset_rec(p_quote_id NUMBER) IS
2837: SELECT 'x'
2838: FROM OKL_QUICK_QUOTE_LINES_B OAL
2839: WHERE OAL.QUICK_QUOTE_ID=p_quote_id
2840: AND OAL.TYPE='ITEM_CATEGORY';
2841:
2842: lp_quote_id NUMBER;