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_PRICE_PLANS_B

Line 618: l_aw_uom qpr_price_plans_b.base_uom_code%type;

614: l_regression_slope number;
615: l_regression_intercept number;
616: l_deal_uom_pp_conv number;
617: l_deal_curr_pp_conv number;
618: l_aw_uom qpr_price_plans_b.base_uom_code%type;
619: l_aw_curr qpr_price_plans_b.currency_code%type;
620: begin
621: for c_mdl_lines_rec in c_mdl_lines loop
622: begin

Line 619: l_aw_curr qpr_price_plans_b.currency_code%type;

615: l_regression_intercept number;
616: l_deal_uom_pp_conv number;
617: l_deal_curr_pp_conv number;
618: l_aw_uom qpr_price_plans_b.base_uom_code%type;
619: l_aw_curr qpr_price_plans_b.currency_code%type;
620: begin
621: for c_mdl_lines_rec in c_mdl_lines loop
622: begin
623: select pn_line_id into l_line_id

Line 661: qpr_price_plans_b pp

657: l_recommended_price,
658: l_regression_intercept,
659: l_aw_uom, l_aw_curr
660: from qpr_pn_lines l, qpr_pn_prices pr, qpr_pn_pr_types prt,
661: qpr_price_plans_b pp
662: where l.parent_pn_line_id= c_mdl_lines_rec.source_ref_line_id
663: and l.response_header_id = p_response_id
664: and l.response_header_id = pr.response_header_id
665: and l.pn_line_id = pr.pn_line_id

Line 783: l_aw_uom qpr_price_plans_b.base_uom_code%type;

779: l_Response_status varchar2(240);
780: l_return_status varchar2(10);
781: l_deal_uom_conv number;
782: l_deal_curr_conv number;
783: l_aw_uom qpr_price_plans_b.base_uom_code%type;
784: l_aw_curr qpr_price_plans_b.currency_code%type;
785: begin
786:
787: log_debug('Populating deal tables...');

Line 784: l_aw_curr qpr_price_plans_b.currency_code%type;

780: l_return_status varchar2(10);
781: l_deal_uom_conv number;
782: l_deal_curr_conv number;
783: l_aw_uom qpr_price_plans_b.base_uom_code%type;
784: l_aw_curr qpr_price_plans_b.currency_code%type;
785: begin
786:
787: log_debug('Populating deal tables...');
788:

Line 1068: from qpr_price_plans_b

1064: if (int_lines_rec.REGRESSION_INTERCEPT <> 0
1065: or int_lines_rec.REGRESSION_SLOPE <> 0) then
1066: select base_uom_code, currency_code
1067: into l_aw_uom, l_aw_curr
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(