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_PN_LINES

Line 55: from qpr_pn_pr_details a, qpr_pn_lines l

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
56: where a.response_header_id = p_response_hdr_id
57: and a.pn_line_id = l.pn_line_id
58: group by a.erosion_type, a.pn_line_id;
59:

Line 73: from qpr_pn_pr_details a, qpr_pn_lines l

69: select
70: erosion_type, erosion_name, erosion_desc,
71: decode(nvl(p_mdl_qty,0), 0, 0, sum(a.erosion_amount)/p_mdl_qty) as unit_adj,
72: decode(nvl(p_mdl_qty,0), 0, 0, sum(a.erosion_amount)) as erosion_amount
73: from qpr_pn_pr_details a, qpr_pn_lines l
74: where l.parent_pn_line_id= p_top_mdl_src_line_id
75: and l.response_header_id = p_response_hdr_id
76: and a.pn_line_id = l.pn_line_id
77: group by erosion_type, erosion_name, erosion_desc;

Line 226: from qpr_pn_prices pr1, qpr_pn_prices pr2, qpr_pn_lines l, qpr_pn_pr_types prt

222: select pr1.pn_pr_type_id, sum(pr1.amount) amount,
223: decode(sum(pr2.amount),0,0, 100 * sum(pr1.amount)/sum(pr2.amount))
224: percent_price,
225: decode(sum(l.ordered_qty), 0, 0, sum(pr1.amount)* count(l.pn_line_id)/sum(l.ordered_qty)) unit_price
226: from qpr_pn_prices pr1, qpr_pn_prices pr2, qpr_pn_lines l, qpr_pn_pr_types prt
227: where pr1.response_header_id = p_response_hdr_id
228: and pr1.response_header_id = l.response_header_id
229: and pr1.pn_line_id = l.pn_line_id
230: and pr1.response_header_id = pr2.response_header_id

Line 605: from qpr_pn_lines

601:
602: procedure insert_model_lines(p_response_id number, p_deal_date date) is
603: cursor c_mdl_lines is
604: select *
605: from qpr_pn_lines
606: where response_header_id = p_response_id
607: and item_type_code in ('MDL', 'KIT');
608:
609: l_LIST_PRICE number;

Line 624: from qpr_pn_lines

620: begin
621: for c_mdl_lines_rec in c_mdl_lines loop
622: begin
623: select pn_line_id into l_line_id
624: from qpr_pn_lines
625: where source_ref_line_id = c_mdl_lines_rec.source_ref_line_id
626: and source_ref_hdr_id = c_mdl_lines_rec.source_ref_hdr_id
627: and source_id = c_mdl_lines_rec.source_id
628: and response_header_id = p_response_id

Line 660: from qpr_pn_lines l, qpr_pn_prices pr, qpr_pn_pr_types prt,

656: l_PROPOSED_PRICE,
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

Line 698: update qpr_pn_lines set PROPOSED_PRICE = l_PROPOSED_PRICE,

694: c_mdl_lines_rec.revised_oq * l_deal_uom_pp_conv;
695: end if;
696: end if;
697:
698: update qpr_pn_lines set PROPOSED_PRICE = l_PROPOSED_PRICE,
699: RECOMMENDED_PRICE = l_recommended_price,
700: REGRESSION_SLOPE = l_regression_slope,
701: LINE_PRICING_SCORE = l_LINE_PRICING_SCORE
702: where pn_line_id = l_line_id;

Line 726: update qpr_pn_lines

722: false,
723: c_mdl_lines_rec.pn_line_id);
724:
725: log_debug('Update parent_pn_line_id for child lines of model...');
726: update qpr_pn_lines
727: set parent_pn_line_id = l_line_id
728: where (parent_pn_line_id= c_mdl_lines_rec.source_ref_line_id
729: or pn_line_id = c_mdl_lines_rec.pn_line_id)
730: and pn_line_id <> l_line_id

Line 763: select * from qpr_pn_lines

759: and pn_req_line_status_flag = 'I'
760: order by pn_int_line_id;
761:
762: cursor c_pn_lines(p_resp_hdr_id number) is
763: select * from qpr_pn_lines
764: where response_header_id = p_resp_hdr_id
765: and item_type_code <> 'DUMMY_PARENT';
766:
767: l_request_id number;

Line 950: insert into qpr_pn_lines(PN_LINE_ID,

946: int_lines_rec.ITEM_TYPE_CODE = 'KIT' then
947: log_debug('Inserting rolled up model for model/kit line');
948: l_line_num := substrb(int_lines_rec.SOURCE_REQUEST_LINE_NUMBER, 1,
949: instrb(int_lines_rec.SOURCE_REQUEST_LINE_NUMBER, '.' , 1, 1)- 1);
950: insert into qpr_pn_lines(PN_LINE_ID,
951: RESPONSE_HEADER_ID,
952: REQUEST_HEADER_ID,
953: PRICE_PLAN_ID,
954: SOURCE_REF_LINE_ID,

Line 1001: values(QPR_PN_LINES_S.nextval,

997: CREATED_BY,
998: LAST_UPDATE_DATE,
999: LAST_UPDATE_LOGIN,
1000: LAST_UPDATED_BY)
1001: values(QPR_PN_LINES_S.nextval,
1002: l_response_id,
1003: l_request_id,
1004: int_lines_rec.PRICE_PLAN_ID,
1005: int_lines_rec.SOURCE_REF_LINE_ID,

Line 1111: insert into qpr_pn_lines(PN_LINE_ID,

1107: end if;
1108:
1109: log_debug('Recommended_price = ' || l_recommend_price);
1110:
1111: insert into qpr_pn_lines(PN_LINE_ID,
1112: RESPONSE_HEADER_ID,
1113: REQUEST_HEADER_ID,
1114: PRICE_PLAN_ID,
1115: SOURCE_REF_LINE_ID,

Line 1162: values(QPR_PN_LINES_S.nextval,

1158: CREATED_BY,
1159: LAST_UPDATE_DATE,
1160: LAST_UPDATE_LOGIN,
1161: LAST_UPDATED_BY)
1162: values(QPR_PN_LINES_S.nextval,
1163: l_response_id,
1164: l_request_id,
1165: int_lines_rec.PRICE_PLAN_ID,
1166: int_lines_rec.SOURCE_REF_LINE_ID,

Line 1250: update qpr_pn_lines set line_pricing_score = round(l_line_score, 2)

1246: log_debug('Determine Line score');
1247: l_line_score := get_line_score(lines_rec.pn_line_id,
1248: lines_rec.recommended_price);
1249:
1250: update qpr_pn_lines set line_pricing_score = round(l_line_score, 2)
1251: where pn_line_id = lines_rec.pn_line_id;
1252: end loop; -- 2nd lines loop
1253:
1254: -- insert adjustment records for header and line total adjustment

Line 1270: from qpr_pn_lines l, qpr_pn_prices pr, qpr_pn_pr_types prt

1266: begin
1267: select round(sum(nvl(l.line_pricing_score,0)*nvl(pr.amount,0))/
1268: sum(nvl(pr.amount,0)), 2)
1269: into l_total_score
1270: from qpr_pn_lines l, qpr_pn_prices pr, qpr_pn_pr_types prt
1271: where l.response_header_id = l_response_id
1272: and pr.response_header_id= l.response_header_id
1273: and pr.pn_line_id = l.pn_line_id
1274: and pr.pn_pr_type_id = prt.pn_pr_type_id

Line 1994: select * from qpr_pn_lines

1990: retcode out nocopy varchar2,
1991: p_response_hdr_id in number,
1992: p_new_resp_hdr_id out nocopy number) is
1993: cursor c_pn_lines is
1994: select * from qpr_pn_lines
1995: where response_header_id = p_response_hdr_id;
1996:
1997: -- need hdr records also so outer join --
1998: -- join between lines ---

Line 2005: from qpr_pn_pr_details pr, qpr_pn_lines ol, qpr_pn_lines nl

2001: -- item_type_code, since the model/dummy_parent have same source_ref_line_id
2002: cursor c_pn_pr_det(p_new_resp_hdr_id number) is
2003: select pr.erosion_type, pr.erosion_name, pr.erosion_desc,
2004: pr.erosion_per_unit,pr.erosion_amount, nl.pn_line_id
2005: from qpr_pn_pr_details pr, qpr_pn_lines ol, qpr_pn_lines nl
2006: where
2007: pr.response_header_id = p_response_hdr_id
2008: and pr.response_header_id = ol.response_header_id(+)
2009: and pr.pn_line_id = ol.pn_line_id(+)

Line 2020: from qpr_pn_prices o, qpr_pn_lines nl, qpr_pn_lines ol

2016: -- need hdr records also so outer join --
2017: cursor c_pn_prices(p_new_resp_hdr_id number) is
2018: select o.pn_pr_type_id, o.unit_price, o.amount,o.percent_price,
2019: nl.pn_line_id
2020: from qpr_pn_prices o, qpr_pn_lines nl, qpr_pn_lines ol
2021: where o.response_header_id = p_response_hdr_id
2022: and ol.response_header_id(+) = o.response_header_id
2023: and ol.pn_line_id(+) = o.pn_line_id
2024: and nl.response_header_id(+) = p_new_resp_hdr_id

Line 2038: qpr_pn_prices o, qpr_pn_lines ol,

2034: op.POLICY_AMOUNT,
2035: op.policy_line_id,
2036: n.pn_price_id
2037: from qpr_pn_policies op,
2038: qpr_pn_prices o, qpr_pn_lines ol,
2039: qpr_pn_lines nl, qpr_pn_prices n
2040: where op.pn_price_id = o.pn_price_id
2041: and o.response_header_id = p_response_hdr_id
2042: and ol.response_header_id = o.response_header_id

Line 2039: qpr_pn_lines nl, qpr_pn_prices n

2035: op.policy_line_id,
2036: n.pn_price_id
2037: from qpr_pn_policies op,
2038: qpr_pn_prices o, qpr_pn_lines ol,
2039: qpr_pn_lines nl, qpr_pn_prices n
2040: where op.pn_price_id = o.pn_price_id
2041: and o.response_header_id = p_response_hdr_id
2042: and ol.response_header_id = o.response_header_id
2043: and ol.pn_line_id = o.pn_line_id

Line 2130: insert into qpr_pn_lines(PN_LINE_ID,

2126: errbuf := sqlerrm || 'Source Response not found';
2127: return;
2128: end;
2129: for lines_rec in c_pn_lines loop
2130: insert into qpr_pn_lines(PN_LINE_ID,
2131: RESPONSE_HEADER_ID,
2132: REQUEST_HEADER_ID,
2133: PRICE_PLAN_ID,
2134: SOURCE_REF_LINE_ID,

Line 2180: values(QPR_PN_LINES_S.nextval,

2176: CREATED_BY,
2177: LAST_UPDATE_DATE,
2178: LAST_UPDATE_LOGIN,
2179: LAST_UPDATED_BY)
2180: values(QPR_PN_LINES_S.nextval,
2181: l_response_id,
2182: lines_rec.REQUEST_HEADER_ID,
2183: lines_rec.PRICE_PLAN_ID,
2184: lines_rec.SOURCE_REF_LINE_ID,

Line 2409: from qpr_pn_lines l, qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req

2405: if nvl(i_is_qty_changed, 'N') = 'Y' then
2406:
2407: select l.uom_code, req.instance_id,l.currency_code
2408: into l_uom_code, l_deal_instance, l_deal_currency
2409: from qpr_pn_lines l, qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req
2410: where l.pn_line_id = i_line_id
2411: and l.response_header_id = i_response_header_id
2412: and l.response_header_id = resp.response_header_id
2413: and resp.request_header_id = req.request_header_id