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_MEASURE_DATA

Line 35: from qpr_measure_data where instance_id = p_instance_id

31: t_cost_level char240_type;
32:
33: cursor c_sales(p_date_from date, p_date_to date) is
34: select measure_value_id, ord_level_value
35: from qpr_measure_data where instance_id = p_instance_id
36: and measure_type_code = 'SALESDATA'
37: and time_level_value between p_date_from and p_date_to
38: and measure1_char in ('STANDARD','SERVICE');
39:

Line 42: from qpr_measure_data where instance_id = p_instance_id

38: and measure1_char in ('STANDARD','SERVICE');
39:
40: cursor c_sales_mdl(p_date_from date, p_date_to date) is
41: select measure_value_id, ord_level_value
42: from qpr_measure_data where instance_id = p_instance_id
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:

Line 241: update qpr_measure_data

237:
238: if l_ctr > 0 then
239: fnd_file.put_line(fnd_file.log, 'Updating kit items...');
240: FORALL I IN 1..t_ord_val.COUNT
241: update qpr_measure_data
242: set measure15_number = t_cost(i),
243: cos_level_value = t_cost_level(i),
244: LAST_UPDATE_DATE = d_sysdate,
245: LAST_UPDATED_BY = l_user_id,

Line 291: update qpr_measure_data

287:
288: if l_ctr > 0 then
289: fnd_file.put_line(fnd_file.log, 'Updating ato model items...');
290: FORALL I IN 1..t_ord_val.COUNT
291: update qpr_measure_data
292: set measure15_number = t_cost(i),
293: cos_level_value = t_cost_level(i),
294: LAST_UPDATE_DATE = d_sysdate,
295: LAST_UPDATED_BY = l_user_id,

Line 341: update qpr_measure_data

337:
338: if l_ctr > 0 then
339: fnd_file.put_line(fnd_file.log, 'Updating pto model items...');
340: FORALL I IN 1..t_ord_val.COUNT
341: update qpr_measure_data
342: set measure15_number = t_cost(i),
343: cos_level_value = t_cost_level(i),
344: LAST_UPDATE_DATE = d_sysdate,
345: LAST_UPDATED_BY = l_user_id,

Line 501: update qpr_measure_data

497:
498: if l_ctr > 0 then
499: fnd_file.put_line(fnd_file.log,'Updating sales data with cost measure...');
500: FORALL I IN 1..c_cost_data.ord_level_value.COUNT
501: update qpr_measure_data
502: set measure15_number = (c_cost_data.cost_value(I) *
503: c_cost_data.ord_quantity(I)),
504: cos_level_value = c_cost_data.cos_level_value(I),
505: LAST_UPDATE_DATE = d_sysdate,

Line 893: insert into QPR_MEASURE_DATA(MEASURE_VALUE_ID,

889: ----- Update Measure data ---
890: fnd_file.put_line(fnd_file.log,'Staging Measure data...');
891: FORALL I IN
892: c_offadj_data.level1_value.FIRST..c_offadj_data.level1_value.LAST
893: insert into QPR_MEASURE_DATA(MEASURE_VALUE_ID,
894: INSTANCE_ID,
895: MEASURE_TYPE_CODE,
896: ADJ_LEVEL_VALUE,
897: TIME_LEVEL_VALUE,

Line 910: values (QPR_MEASURE_DATA_S.nextval,

906: LAST_UPDATE_DATE ,
907: LAST_UPDATED_BY ,
908: LAST_UPDATE_LOGIN ,
909: REQUEST_ID)
910: values (QPR_MEASURE_DATA_S.nextval,
911: -999,
912: 'OFFADJDATA',
913: c_offadj_data.level1_value(I),
914: c_offadj_data.date_value(I),

Line 964: (select sum(om.measure2_number) from qpr_measure_data om where om.instance_id=p_instance_id

960: om_alloc.time_level_value,
961: temp.MEASURE1_NUMBER, --qty_ordered
962: temp.MEASURE2_NUMBER, --unit_selling_price
963: temp.MEASURE3_NUMBER, --extended_amount
964: (select sum(om.measure2_number) from qpr_measure_data om where om.instance_id=p_instance_id
965: and om.measure_type_code = 'SALESDATA'
966: and om.time_level_value between p_from_date and p_to_date
967: and om.cus_level_value = temp.cus_level_value
968: and om.prd_level_value = nvl(temp.prd_level_value, om.prd_level_value)

Line 973: from qpr_measure_data temp, qpr_measure_data om_alloc

969: and om.org_level_value = nvl(temp.org_level_value, om.org_level_value)
970: ) as total_amount,
971: om_alloc.measure1_number,
972: om_alloc.measure2_number
973: from qpr_measure_data temp, qpr_measure_data om_alloc
974: where temp.instance_id=-999
975: and temp.measure_type_code = 'OFFADJDATA'
976: and temp.request_id = fnd_global.conc_request_id
977: and om_alloc.instance_id=p_instance_id

Line 1040: delete qpr_measure_data

1036: if c_offadj_data.level1_value.count>0 then
1037: fnd_file.put_line(fnd_file.log,'Deleting measures if exists ');
1038: begin
1039: forall I in 1..c_offadj_data.level1_value.count
1040: delete qpr_measure_data
1041: where instance_id=p_instance_id
1042: and measure_type_code= 'OFFADJDATA'
1043: and ord_level_value=c_offadj_data.level2_value(I)
1044: and adj_level_value=c_offadj_data.level1_value(I);

Line 1054: insert into QPR_MEASURE_DATA(

1050: end;
1051: begin
1052: fnd_file.put_line(fnd_file.log,'Inserting measures ');
1053: forall I in 1..c_offadj_data.level1_value.count
1054: insert into QPR_MEASURE_DATA(
1055: MEASURE_VALUE_ID,
1056: MEASURE_TYPE_CODE,
1057: INSTANCE_ID,
1058: ORD_LEVEL_VALUE,

Line 1074: (QPR_MEASURE_DATA_S.nextval,

1070: LAST_UPDATE_DATE ,
1071: LAST_UPDATED_BY ,
1072: LAST_UPDATE_LOGIN ,
1073: REQUEST_ID) values
1074: (QPR_MEASURE_DATA_S.nextval,
1075: 'OFFADJDATA',
1076: p_instance_id,
1077: c_offadj_data.level2_value(I),
1078: c_offadj_data.level3_value(I),

Line 1116: delete qpr_measure_data temp

1112: end loop; --c_offadj
1113:
1114: close c_offadj;
1115: begin
1116: delete qpr_measure_data temp
1117: where temp.instance_id=-999
1118: and temp.measure_type_code = 'OFFADJDATA'
1119: and temp.request_id = l_request_id;
1120: fnd_file.put_line(fnd_file.log, 'Deleted '|| sql%rowcount ||' temp records');

Line 1162: from qpr_measure_data md,

1158: nvl(md.measure15_number,0) as cost,
1159: nvl(md2.offadj_amt, 0) as offadj_amt,
1160: nvl(md.measure2_number, 0 ) as gross_revenue,
1161: nvl(md1.freight_amount, 0) as freight_amount
1162: from qpr_measure_data md,
1163: (select sum(m1.measure1_number) freight_amount, m1.ord_level_Value,
1164: m1.time_level_Value
1165: from qpr_measure_data m1
1166: where m1.instance_id = p_instance_id

Line 1165: from qpr_measure_data m1

1161: nvl(md1.freight_amount, 0) as freight_amount
1162: from qpr_measure_data md,
1163: (select sum(m1.measure1_number) freight_amount, m1.ord_level_Value,
1164: m1.time_level_Value
1165: from qpr_measure_data m1
1166: where m1.instance_id = p_instance_id
1167: and m1.measure_type_code = 'ADJUSTMENT'
1168: and m1.measure1_char = 'FREIGHT_CHARGE'
1169: and m1.time_level_value between date_from and date_to

Line 1173: from qpr_measure_data m2

1169: and m1.time_level_value between date_from and date_to
1170: group by m1.ord_level_value, m1.time_level_value) md1,
1171: (select sum(m2.measure1_number) offadj_amt, m2.ord_level_value,
1172: m2.time_level_value
1173: from qpr_measure_data m2
1174: where m2.measure_type_code = 'OFFADJDATA'
1175: and m2.instance_id = p_instance_id
1176: and m2.TIME_LEVEL_VALUE between date_from and date_to
1177: group by m2.ORD_LEVEL_VALUE, m2.TIME_LEVEL_VALUE) md2

Line 1225: update qpr_measure_data

1221:
1222: fnd_file.put_line(fnd_file.log,
1223: 'Updated Records=' || rec_upd_det.measure_value_id.count);
1224: forall i in rec_upd_det.measure_value_id.first..rec_upd_det.measure_value_id.last
1225: update qpr_measure_data
1226: set measure5_number = rec_upd_det.measure1(i),
1227: measure14_number = rec_upd_det.measure2(i),
1228: measure17_number = rec_upd_det.measure3(i),
1229: measure20_number = rec_upd_det.measure4(i),

Line 1275: from qpr_measure_data

1271: cursor c_measures(p_date_from date, p_date_to date) is
1272: select measure_value_id,cus_level_value, geo_level_value, org_level_value,
1273: prd_level_value, chn_level_value ,rep_level_value , ord_level_value,
1274: time_level_value
1275: from qpr_measure_data
1276: where instance_id = p_instance_id
1277: and measure_type_code = 'SALESDATA'
1278: and time_level_value between p_date_from and p_date_to
1279: order by cus_level_value, geo_level_value, org_level_value,

Line 1404: update qpr_measure_data set psg_level_value = t_psg_val(i),

1400:
1401: fnd_file.put_line(fnd_file.log,
1402: 'updating pricing segments for measuretype:salesdata');
1403: forall i in t_meas_val_id.first..t_meas_val_id.last
1404: update qpr_measure_data set psg_level_value = t_psg_val(i),
1405: last_update_date = sysdate,
1406: last_updated_by = fnd_global.user_id,
1407: last_update_login = fnd_global.login_id,
1408: request_id = fnd_global.conc_request_id

Line 1413: update qpr_measure_data set psg_level_value = t_psg_val(i),

1409: where measure_value_id = t_meas_val_id(i);
1410:
1411: fnd_file.put_line(fnd_file.log,'Updating measuretypes:ADJUSTMENT,OFFADJDATA');
1412: forall i in t_meas_val_id.first..t_meas_val_id.last
1413: update qpr_measure_data set psg_level_value = t_psg_val(i),
1414: last_update_date = sysdate,
1415: last_updated_by = fnd_global.user_id,
1416: last_update_login = fnd_global.login_id,
1417: request_id = fnd_global.conc_request_id