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_SPECIAL_ETL dependencies on QPR_PLAN_MEASURES

Line 47: /** Mapping info in qpr_plan_measures *

43: and measure_type_code = 'SALESDATA'
44: and time_level_value between p_date_from and p_date_to
45: and measure1_char not in ('STANDARD','SERVICE');
46:
47: /********** Mapping info in qpr_plan_measures *********
48: price_plan_id = Request_id
49: price_plan_meas_grp_id = 999
50: price_plan_meas_grp_name = COST
51: date_attribute = booked_date

Line 72: from qpr_plan_measures m3

68: 'KIT', (case when (to_number(m2.attribute_9) <> 0) then
69: to_number(m2.attribute_9)
70: else
71: (select sum(m3.attribute_9)
72: from qpr_plan_measures m3
73: where m3.price_plan_id= l_request_id
74: and m3.price_plan_meas_grp_id = 999
75: and m3.attribute_6 = 'INCLUDED'
76: and m3.attribute_5 = m2.attribute_4)

Line 79: from qpr_plan_measures m1, qpr_plan_measures m2

75: and m3.attribute_6 = 'INCLUDED'
76: and m3.attribute_5 = m2.attribute_4)
77: end)
78: ) * (m2.attribute_11), 0) cost
79: from qpr_plan_measures m1, qpr_plan_measures m2
80: where m1.price_plan_id= l_request_id
81: and m1.price_plan_meas_grp_id = 999
82: and m2.price_plan_id= l_request_id
83: and m2.price_plan_meas_grp_id = 999

Line 105: from qpr_plan_measures c, qpr_plan_measures o

101: from
102: (select nvl(sum(c.attribute_9)/count(c.attribute_9) -
103: sum(o.attribute_9) , 0) cost_to_alloc,
104: o.attribute_8
105: from qpr_plan_measures c, qpr_plan_measures o
106: where o.price_plan_id= l_request_id
107: and o.price_plan_meas_grp_id = 999
108: and o.attribute_6 = 'OPTION'
109: and o.attribute_8 is not null

Line 118: from qpr_plan_measures m3

114: and c.attribute_6(+) = 'CONFIG'
115: group by o.attribute_8) t,
116: (select sum(m3.attribute_10 * m3.attribute_11) list_price_rev,
117: m3.attribute_8
118: from qpr_plan_measures m3
119: where m3.price_plan_id= l_request_id
120: and m3.price_plan_meas_grp_id = 999
121: and m3.attribute_6 in('ATOMODEL', 'ATOCLASS')
122: group by m3.attribute_8) t1

Line 127: from qpr_plan_measures m1, qpr_plan_measures m2

123: where t1.attribute_8 = m2.attribute_8
124: and t.attribute_8(+) = t1.attribute_8
125: )
126: ) * (m2.attribute_11) , 0) cost
127: from qpr_plan_measures m1, qpr_plan_measures m2
128: where m1.price_plan_id= l_request_id
129: and m1.price_plan_meas_grp_id = 999
130: and m2.price_plan_id= l_request_id
131: and m2.price_plan_meas_grp_id = 999

Line 152: from qpr_plan_measures c

148: m2.attribute_11 / t1.list_price_rev))
149: end
150: from
151: (select nvl(sum(c.attribute_9) , 0) cost_to_alloc , c.attribute_4
152: from qpr_plan_measures c
153: where c.price_plan_id = l_request_id
154: and c.price_plan_meas_grp_id = 999
155: and c.attribute_6 = 'INCLUDED'
156: group by c.attribute_4

Line 160: from qpr_plan_measures m3

156: group by c.attribute_4
157: ) t,
158: (select sum(m3.attribute_10 * m3.attribute_11) list_price_rev,
159: m3.attribute_4
160: from qpr_plan_measures m3
161: where m3.price_plan_id= l_request_id
162: and m3.price_plan_meas_grp_id = 999
163: and m3.attribute_6 in('PTOMODEL', 'PTOCLASS')
164: group by m3.attribute_4) t1

Line 180: from qpr_plan_measures c, qpr_plan_measures o

176: from
177: ( select nvl(sum(c.attribute_9)/count(c.attribute_9) -
178: sum(o.attribute_9) , 0) cost_to_alloc
179: , o.attribute_8
180: from qpr_plan_measures c, qpr_plan_measures o
181: where o.price_plan_id = l_request_id
182: and o.price_plan_meas_grp_id = 999
183: and o.attribute_6 = 'OPTION'
184: and o.attribute_8 is not null

Line 193: from qpr_plan_measures m3

189: and c.attribute_6(+) = 'CONFIG'
190: group by o.attribute_8) t,
191: (select sum(m3.attribute_10 * m3.attribute_11) list_price_rev,
192: m3.attribute_8
193: from qpr_plan_measures m3
194: where m3.price_plan_id= l_request_id
195: and m3.price_plan_meas_grp_id = 999
196: and m3.attribute_6 in('ATOMODEL', 'ATOCLASS')
197: group by m3.attribute_8) t1

Line 203: from qpr_plan_measures m1, qpr_plan_measures m2

199: and t.attribute_8(+) = t1.attribute_8
200: )
201: end
202: ) * m2.attribute_11 , 0) cost
203: from qpr_plan_measures m1, qpr_plan_measures m2
204: where m1.price_plan_id= l_request_id
205: and m1.price_plan_meas_grp_id = 999
206: and m2.price_plan_id= l_request_id
207: and m2.price_plan_meas_grp_id = 999

Line 657: insert into qpr_plan_measures(price_plan_data_id,

653:
654: fnd_file.put_line(fnd_file.log, 'Inserting fact records in staging table');
655: forall i in c_cost_data.ord_level_value.first..
656: c_cost_data.ord_level_value.last
657: insert into qpr_plan_measures(price_plan_data_id,
658: price_plan_id,
659: price_plan_meas_grp_id,
660: price_plan_meas_grp_name,
661: date_attribute,

Line 679: values(qpr_plan_measures_s.nextval,

675: LAST_UPDATE_DATE,
676: LAST_UPDATED_BY,
677: LAST_UPDATE_LOGIN,
678: REQUEST_ID)
679: values(qpr_plan_measures_s.nextval,
680: l_request_id,
681: 999, 'COST',
682: c_cost_data.booked_date(i),
683: c_cost_data.INVENTORY_ITEM_ID(i),

Line 717: delete qpr_plan_measures temp

713: t_ord_meas.delete;
714:
715: fnd_file.put_line(fnd_file.log, 'Deleting staging table records ..');
716: begin
717: delete qpr_plan_measures temp
718: where temp.price_plan_meas_grp_id=999
719: and temp.price_plan_id = l_request_id;
720: fnd_file.put_line(fnd_file.log, 'Deleted '||sql%rowcount ||'records');
721: end;