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.QPR_DEAL_ETL dependencies on QPR_SR_UTIL

Line 45: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_pk,

41: and source_id = p_src_id;
42:
43: cursor c_tot_adj is
44: select a.pn_line_id, 'ALL_' || erosion_type,
45: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_pk,
46: 'COST', qpr_sr_util.get_all_cos_pk,
47: 'OFFINVOICE',
48: qpr_sr_util.get_all_oad_pk, qpr_sr_util.get_null_pk) erosion_name,
49: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_desc,

Line 46: 'COST', qpr_sr_util.get_all_cos_pk,

42:
43: cursor c_tot_adj is
44: select a.pn_line_id, 'ALL_' || erosion_type,
45: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_pk,
46: 'COST', qpr_sr_util.get_all_cos_pk,
47: 'OFFINVOICE',
48: qpr_sr_util.get_all_oad_pk, qpr_sr_util.get_null_pk) erosion_name,
49: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_desc,
50: 'COST', qpr_sr_util.get_all_cos_desc,

Line 48: qpr_sr_util.get_all_oad_pk, qpr_sr_util.get_null_pk) erosion_name,

44: select a.pn_line_id, 'ALL_' || erosion_type,
45: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_pk,
46: 'COST', qpr_sr_util.get_all_cos_pk,
47: 'OFFINVOICE',
48: qpr_sr_util.get_all_oad_pk, qpr_sr_util.get_null_pk) erosion_name,
49: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_desc,
50: 'COST', qpr_sr_util.get_all_cos_desc,
51: 'OFFINVOICE', qpr_sr_util.get_all_oad_desc, qpr_sr_util.get_null_desc)
52: erosion_desc,

Line 49: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_desc,

45: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_pk,
46: 'COST', qpr_sr_util.get_all_cos_pk,
47: 'OFFINVOICE',
48: qpr_sr_util.get_all_oad_pk, qpr_sr_util.get_null_pk) erosion_name,
49: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_desc,
50: 'COST', qpr_sr_util.get_all_cos_desc,
51: 'OFFINVOICE', qpr_sr_util.get_all_oad_desc, qpr_sr_util.get_null_desc)
52: erosion_desc,
53: decode(sum(l.ordered_qty), 0 ,0, sum(erosion_amount) * count(erosion_type)/sum(l.ordered_qty)),

Line 50: 'COST', qpr_sr_util.get_all_cos_desc,

46: 'COST', qpr_sr_util.get_all_cos_pk,
47: 'OFFINVOICE',
48: qpr_sr_util.get_all_oad_pk, qpr_sr_util.get_null_pk) erosion_name,
49: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_desc,
50: 'COST', qpr_sr_util.get_all_cos_desc,
51: 'OFFINVOICE', qpr_sr_util.get_all_oad_desc, qpr_sr_util.get_null_desc)
52: erosion_desc,
53: decode(sum(l.ordered_qty), 0 ,0, sum(erosion_amount) * count(erosion_type)/sum(l.ordered_qty)),
54: sum(erosion_amount)

Line 51: 'OFFINVOICE', qpr_sr_util.get_all_oad_desc, qpr_sr_util.get_null_desc)

47: 'OFFINVOICE',
48: qpr_sr_util.get_all_oad_pk, qpr_sr_util.get_null_pk) erosion_name,
49: decode(erosion_type, 'ONINVOICE', qpr_sr_util.get_all_adj_desc,
50: 'COST', qpr_sr_util.get_all_cos_desc,
51: 'OFFINVOICE', qpr_sr_util.get_all_oad_desc, qpr_sr_util.get_null_desc)
52: erosion_desc,
53: decode(sum(l.ordered_qty), 0 ,0, sum(erosion_amount) * count(erosion_type)/sum(l.ordered_qty)),
54: sum(erosion_amount)
55: from qpr_pn_pr_details a, qpr_pn_lines l

Line 424: l_curr_conv := qpr_sr_util.ods_curr_conversion(null, p_deal_curr,

420: loop
421: rec_pn_pol_ins.PN_PRICE_ID(l_pol_ctr) := r_pn_pric.PN_PRICE_ID;
422: end loop;
423: if g_t_pol_det(i).LIMIT_VALUE_TYPE_CODE = 'AMOUNT' then
424: l_curr_conv := qpr_sr_util.ods_curr_conversion(null, p_deal_curr,
425: null, p_deal_date, l_deal_instance);
426: if g_t_pol_det(i).POLICY_MEASURE_TYPE_CODE = 'COST' then
427: l_pol_price := p_list_price -
428: (nvl(g_t_pol_det(i).REF_LIMIT_VALUE,0) * l_curr_conv);

Line 645: (case when (qpr_sr_util.ods_uom_conv(

641: sum(nvl(pr.amount,0))) ,
642: sum(PROPOSED_PRICE * REVISED_OQ),
643: sum(RECOMMENDED_PRICE * REVISED_OQ),
644: sum(nvl(REGRESSION_INTERCEPT,0) *
645: (case when (qpr_sr_util.ods_uom_conv(
646: l.inventory_item_id,
647: l.UOM_CODE,
648: pp.base_uom_code, pp.instance_id, null) < 0) then
649: 0 else qpr_sr_util.ods_uom_conv(

Line 649: 0 else qpr_sr_util.ods_uom_conv(

645: (case when (qpr_sr_util.ods_uom_conv(
646: l.inventory_item_id,
647: l.UOM_CODE,
648: pp.base_uom_code, pp.instance_id, null) < 0) then
649: 0 else qpr_sr_util.ods_uom_conv(
650: l.inventory_item_id,
651: l.UOM_CODE,
652: pp.base_uom_code, pp.instance_id, null) end)
653: * REVISED_OQ),

Line 678: l_deal_uom_pp_conv := qpr_sr_util.ods_uom_conv(

674: l_regression_slope := 0;
675: else
676: l_PROPOSED_PRICE:= l_PROPOSED_PRICE/c_mdl_lines_rec.revised_oq;
677: l_recommended_price := l_recommended_price/c_mdl_lines_rec.revised_oq;
678: l_deal_uom_pp_conv := qpr_sr_util.ods_uom_conv(
679: c_mdl_lines_rec.inventory_item_id,
680: c_mdl_lines_rec.UOM_CODE, l_aw_uom,
681: l_deal_instance,null);
682: l_deal_curr_pp_conv := qpr_sr_util.ods_curr_conversion(

Line 682: l_deal_curr_pp_conv := qpr_sr_util.ods_curr_conversion(

678: l_deal_uom_pp_conv := qpr_sr_util.ods_uom_conv(
679: c_mdl_lines_rec.inventory_item_id,
680: c_mdl_lines_rec.UOM_CODE, l_aw_uom,
681: l_deal_instance,null);
682: l_deal_curr_pp_conv := qpr_sr_util.ods_curr_conversion(
683: c_mdl_lines_rec.currency_code,
684: l_aw_curr, null, p_deal_date,
685: l_deal_instance);
686: if l_deal_uom_pp_conv < 0 or l_deal_curr_pp_conv < 0 then

Line 1072: l_deal_uom_conv := qpr_sr_util.ods_uom_conv(

1068: from qpr_price_plans_b
1069: where price_plan_id = int_lines_rec.PRICE_PLAN_ID
1070: and rownum < 2;
1071:
1072: l_deal_uom_conv := qpr_sr_util.ods_uom_conv(
1073: int_lines_rec.inventory_item_id,
1074: int_lines_rec.UOM_CODE,
1075: l_aw_uom, l_deal_instance, null);
1076:

Line 1077: l_deal_curr_conv := qpr_sr_util.ods_curr_conversion(l_aw_curr,

1073: int_lines_rec.inventory_item_id,
1074: int_lines_rec.UOM_CODE,
1075: l_aw_uom, l_deal_instance, null);
1076:
1077: l_deal_curr_conv := qpr_sr_util.ods_curr_conversion(l_aw_curr,
1078: int_lines_rec.currency_code,
1079: null,
1080: c_int_header_rec.PN_REQ_HEADER_CREATION_DATE,
1081: l_deal_instance);

Line 1342: '3', qpr_sr_util.get_oad_ar_cm_type_desc) er_desc,

1338: '2', nvl2(p_pt_code, substr(p_pt_code, 12), 'PaymentTerm-'),
1339: '3', substr(p_rbt_code, 11)) er_name,
1340: decode(num, '1', l.ship_method_long_desc,
1341: '2', l.payment_term_short_desc,
1342: '3', qpr_sr_util.get_oad_ar_cm_type_desc) er_desc,
1343: decode(nvl(l.ordered_qty,0), 0 , 0, decode(num, '1', p_sm_oad_val, '2', p_pt_oad_val,
1344: '3', p_rbt_oad_val)/l.ordered_qty) er_val,
1345: decode(nvl(l.ordered_qty, 0), 0 , 0, decode(num, '1', p_sm_oad_val, '2', p_pt_oad_val,
1346: '3', p_rbt_oad_val)) er_tot_val

Line 1594: l_uom_conversion_odm := qpr_sr_util.uom_conv(

1590: for int_lines_rec in c_int_lines(c_int_header_rec.source_id) loop
1591: log_debug('Source Line Id: '||int_lines_rec.source_ref_line_id);
1592:
1593: if int_lines_rec.uom_code is not null then
1594: l_uom_conversion_odm := qpr_sr_util.uom_conv(
1595: int_lines_rec.UOM_CODE,
1596: int_lines_rec.inventory_item_id,
1597: null);
1598: else

Line 2417: l_uom_conversion_odm := qpr_sr_util.uom_conv(l_uom_code,

2413: and resp.request_header_id = req.request_header_id
2414: and rownum < 2;
2415:
2416: if l_uom_code is not null then
2417: l_uom_conversion_odm := qpr_sr_util.uom_conv(l_uom_code,
2418: i_inventory_item_id, null);
2419: else
2420: l_uom_conversion_odm := 0;
2421: end if;