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_INT_LINES

Line 273: || ' from qpr_pn_int_lines '

269: if p_mdl_qty is not null then
270: log_debug('Calculating price for rolled up model');
271: l_ord_qty := p_mdl_qty;
272: l_sql := ' select sum( ' || r_pr_types.column_name || ' * ordered_qty) '
273: || ' from qpr_pn_int_lines '
274: || ' where top_mdl_src_line_id = :1 and source_ref_hdr_id = :2 '
275: ||' and source_id = :3 and pn_req_line_status_flag = ''I'' ' ;
276: open c_line for l_sql using p_src_ref_line_id, p_src_ref_hdr_id, p_src_id;
277: fetch c_line into l_amount;

Line 292: || ' from qpr_pn_int_lines '

288: else
289: log_debug('Calculate price for quote line: ' || p_src_ref_line_id);
290:
291: l_sql := 'select ' || r_pr_types.column_name || ' ,ordered_qty '
292: || ' from qpr_pn_int_lines '
293: || ' where source_ref_line_id = :1 and source_ref_hdr_id = :2 '
294: || ' and source_id = :3 and pn_req_line_status_flag = ''I'' and rownum < 2';
295:
296: open c_line for l_sql using p_src_ref_line_id, p_src_ref_hdr_id, p_src_id;

Line 756: from qpr_pn_int_lines

752: where pn_int_header_id = p_int_header_id;
753:
754: cursor c_int_lines(p_src_id number) is
755: select *
756: from qpr_pn_int_lines
757: where source_ref_hdr_id = p_src_ref_hdr_id
758: and source_id = p_src_id
759: and pn_req_line_status_flag = 'I'
760: order by pn_int_line_id;

Line 1347: from qpr_pn_int_lines l,

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
1347: from qpr_pn_int_lines l,
1348: (select rownum num from dual connect by level <=3)
1349: where l.source_ref_hdr_id = p_source_ref_hdr_id
1350: and l.source_ref_line_id = p_source_ref_line_id
1351: and l.source_id = p_src_id)

Line 1370: from qpr_pn_int_pr_adjs pr, qpr_pn_int_lines l

1366: begin
1367: select pn_int_pr_adj_id,
1368: l.ordered_qty
1369: into l_adj_id, l_ord_qty
1370: from qpr_pn_int_pr_adjs pr, qpr_pn_int_lines l
1371: where pr.source_ref_hdr_id = p_source_ref_hdr_id
1372: and pr.source_ref_line_id = p_source_ref_line_id
1373: and pr.source_id = p_src_id
1374: and pr.source_ref_line_id = l.source_ref_line_id

Line 1527: || ' from qpr_pn_int_lines'

1523: l_price := l_price - r1.unit_erosion;
1524: end loop;
1525: else
1526: l_sql := 'select ' || r_pr_typ.column_name
1527: || ' from qpr_pn_int_lines'
1528: || ' where source_ref_hdr_id = :1 and source_ref_line_id = :2'
1529: || ' and pn_req_line_status_flag = ''I'' and source_id = :3 '
1530: || ' and rownum < 2';
1531: open c_line for l_sql using p_src_ref_hdr_id, p_src_ref_line_id, p_src_id;

Line 1547: select * from qpr_pn_int_lines

1543: retcode out nocopy varchar2,
1544: p_src_ref_hdr_id in number,
1545: p_pn_int_hdr_id in number) is
1546: cursor c_int_lines(p_src_id number) is
1547: select * from qpr_pn_int_lines
1548: where source_ref_hdr_id = p_src_ref_hdr_id
1549: and source_id = p_src_id
1550: and pn_req_line_status_flag = 'I';
1551:

Line 1560: from qpr_pn_int_lines

1556: and rownum < 2;
1557:
1558: cursor c_line_aw(p_hdr_id number, p_src_id number) is
1559: select distinct price_plan_id
1560: from qpr_pn_int_lines
1561: where source_ref_hdr_id = p_hdr_id
1562: and source_id = p_src_id;
1563:
1564: cursor c_pn_lines(p_hdr_id number, p_price_plan_id number, p_src_id number) is

Line 1565: select * from qpr_pn_int_lines

1561: where source_ref_hdr_id = p_hdr_id
1562: and source_id = p_src_id;
1563:
1564: cursor c_pn_lines(p_hdr_id number, p_price_plan_id number, p_src_id number) is
1565: select * from qpr_pn_int_lines
1566: where source_ref_hdr_id = p_hdr_id
1567: and source_id = p_src_id
1568: and price_plan_id = nvl(p_price_plan_id, price_plan_id);
1569:

Line 1679: update qpr_pn_int_lines

1675: end;
1676: log_debug('Slope:' || l_slope);
1677: log_debug('Intercept:' || l_intercept);
1678:
1679: update qpr_pn_int_lines
1680: set price_plan_id = l_datamart_id,
1681: datamart_name = l_aw_name,
1682: vol_band_sk = l_vol_band,
1683: pr_segment_id = l_pr_segment_id,

Line 1831: from qpr_pn_int_lines

1827: log_debug('Processing Header:' || t_src_hdr_id(i));
1828: l_deal_instance := t_instance(i);
1829: begin
1830: select 1 into l_count_lines
1831: from qpr_pn_int_lines
1832: where source_ref_hdr_id = t_src_hdr_id(i)
1833: and source_id = t_src_id(i)
1834: and pn_req_line_status_flag = 'I' and rownum < 2;
1835: exception

Line 1865: delete qpr_pn_int_lines where source_ref_hdr_id = t_src_hdr_id(i)

1861:
1862: else
1863: delete qpr_pn_int_headers where pn_int_header_id = t_pn_int_hdr(i);
1864:
1865: delete qpr_pn_int_lines where source_ref_hdr_id = t_src_hdr_id(i)
1866: and source_id = t_src_id(i);
1867:
1868: delete qpr_pn_int_pr_adjs where source_ref_hdr_id = t_src_hdr_id(i)
1869: and source_id = t_src_id(i);

Line 1929: from qpr_pn_int_lines

1925:
1926: begin
1927: begin
1928: select 1 into l_count_lines
1929: from qpr_pn_int_lines
1930: where source_ref_hdr_id = l_src_hdr_id
1931: and source_id = p_source_id
1932: and pn_req_line_status_flag = 'I' and rownum < 2;
1933: exception

Line 1973: delete qpr_pn_int_lines where source_ref_hdr_id = l_src_hdr_id

1969: end if;
1970:
1971: delete qpr_pn_int_headers where pn_int_header_id = l_pn_int_hdr;
1972:
1973: delete qpr_pn_int_lines where source_ref_hdr_id = l_src_hdr_id
1974: and source_id = p_source_id;
1975:
1976: delete qpr_pn_int_pr_adjs where source_ref_hdr_id = l_src_hdr_id
1977: and source_id = p_source_id;