DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_QUICK_QUOTE_LINES_B

Line 460: FROM OKL_QUICK_QUOTE_LINES_B qql

456: SELECT value
457: ,basis
458: ,nvl(nvl(end_of_term_value, end_of_term_value_default), 0) end_of_term_amount
459: ,percentage_of_total_cost
460: FROM OKL_QUICK_QUOTE_LINES_B qql
461: WHERE qql.quick_quote_id = p_qq_id
462: AND TYPE = G_ITEMCATEGORY_TYPE; -- Item Category Type
463: -- Cursor to fetch the EOT Type
464: CURSOR get_eot_type( p_qq_id NUMBER )

Line 758: FROM OKL_QUICK_QUOTE_LINES_B qql

754: IS
755: SELECT type
756: ,basis
757: ,value
758: FROM OKL_QUICK_QUOTE_LINES_B qql
759: WHERE qql.quick_quote_id = p_qq_id
760: AND TYPE IN ( G_DOWNPAYMENT_TYPE, -- Down Payment Type
761: G_TRADEIN_TYPE, -- Trade in Type
762: G_SUBSIDY_TYPE -- Subsidy Type

Line 1419: FROM OKL_QUICK_QUOTE_LINES_B qql

1415: SELECT qql.id qq_line_id
1416: ,qql.type type
1417: ,qql.basis basis
1418: ,qql.value value
1419: FROM OKL_QUICK_QUOTE_LINES_B qql
1420: WHERE qql.quick_quote_id = p_qq_id
1421: AND TYPE IN (G_QQ_FEE_EXPENSE,
1422: G_QQ_FEE_PAYMENT)
1423: ORDER BY TYPE;

Line 1441: AND cfo.source_table = 'OKL_QUICK_QUOTE_LINES_B'

1437: ,oty_code oty_code
1438: FROM OKL_CASH_FLOWS cf,
1439: OKL_CASH_FLOW_OBJECTS cfo
1440: WHERE cf.cfo_id = cfo.id
1441: AND cfo.source_table = 'OKL_QUICK_QUOTE_LINES_B'
1442: AND cfo.source_id = p_qq_line_id;
1443: -- Cursor to fetch the Cash Flow Details
1444: CURSOR qq_cash_flow_levels_csr( p_caf_id NUMBER )
1445: IS

Line 5655: FROM OKL_QUICK_QUOTE_LINES_B qql

5651: ,value
5652: ,basis
5653: ,nvl(nvl(end_of_term_value, end_of_term_value_default), 0) end_of_term_amount
5654: ,lease_rate_factor
5655: FROM OKL_QUICK_QUOTE_LINES_B qql
5656: WHERE qql.quick_quote_id = p_qq_id
5657: AND TYPE = G_ITEMCATEGORY_TYPE; -- Item Category Type
5658:
5659: CURSOR get_cat_name(p_category_id IN NUMBER) IS

Line 5674: FROM OKL_QUICK_QUOTE_LINES_B qql

5670: ,SUM(CASE basis
5671: WHEN 'FIXED' THEN value
5672: WHEN 'ASSET_COST' THEN value * p_tot_item_cost * .01
5673: END ) AS fin_value
5674: FROM OKL_QUICK_QUOTE_LINES_B qql
5675: WHERE qql.quick_quote_id = p_qq_id
5676: AND TYPE IN ( G_DOWNPAYMENT_TYPE, -- Down Payment Type
5677: G_TRADEIN_TYPE, -- Trade in Type
5678: G_SUBSIDY_TYPE ) -- Subsidy Type

Line 5934: -- sales team will populate the LRF in OKL_QUICK_QUOTE_LINES_B.

5930: -- Note:
5931: -- When user hasn't picked the LRS for Rate Card pricing and wishes
5932: -- to enter the LRF .. ie. Structured Pricing, Suresh PB has confirmed
5933: -- that irrespective of the line level pricing has been checked or not
5934: -- sales team will populate the LRF in OKL_QUICK_QUOTE_LINES_B.
5935: -- Hence, pricing can just fetch the LRF in OKL_QUICK_QUOTE_LINES_B and
5936: -- then build the cash flows from that ..
5937: -- Get the Months factor!
5938: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

Line 5935: -- Hence, pricing can just fetch the LRF in OKL_QUICK_QUOTE_LINES_B and

5931: -- When user hasn't picked the LRS for Rate Card pricing and wishes
5932: -- to enter the LRF .. ie. Structured Pricing, Suresh PB has confirmed
5933: -- that irrespective of the line level pricing has been checked or not
5934: -- sales team will populate the LRF in OKL_QUICK_QUOTE_LINES_B.
5935: -- Hence, pricing can just fetch the LRF in OKL_QUICK_QUOTE_LINES_B and
5936: -- then build the cash flows from that ..
5937: -- Get the Months factor!
5938: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
5939: p_frequency => p_qq_hdr_rec.target_frequency,

Line 6079: FROM OKL_QUICK_QUOTE_LINES_B qql

6075: -- Cursor Declarations
6076: CURSOR get_deal_size_csr( p_qq_id NUMBER )
6077: IS
6078: SELECT sum(VALUE) deal_size
6079: FROM OKL_QUICK_QUOTE_LINES_B qql
6080: WHERE qql.quick_quote_id = p_qq_id
6081: AND qql.TYPE = G_ITEMCATEGORY_TYPE; -- Item Category Type
6082: -- Local Variables declaration
6083: l_cash_flow_rec so_cash_flows_rec_type;