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_SR_UTIL

Line 370: ' from qpr_sr_cost_data_v'|| qpr_sr_util.get_dblink(p_instance_id)||

366:
367: l_sql:= ' select ord_level_value, booked_date, cos_level_value, unit_cost, '||
368: ' unit_list_price, top_model_line_id, link_to_line_id, item_type_code, '||
369: ' inventory_item_id, component_code, ato_line_id , order_quantity' ||
370: ' from qpr_sr_cost_data_v'|| qpr_sr_util.get_dblink(p_instance_id)||
371: ' where booked_date between :1 and :2 ' ||
372: ' and item_type_code in (''STANDARD'',''SERVICE'')';
373:
374: fnd_file.put_line(fnd_file.log, 'Process Standard and service items..');

Line 464: to_char(qpr_sr_util.get_null_pk),

460: 'COS',
461: 'COSTING',
462: c_cost_data.cos_level_value(I),
463: c_cost_data.cos_level_value(I),
464: to_char(qpr_sr_util.get_null_pk),
465: qpr_sr_util.get_cost_type_desc,
466: to_char(qpr_sr_util.get_all_cos_pk),
467: qpr_sr_util.get_all_cos_desc,
468: d_sysdate,

Line 465: qpr_sr_util.get_cost_type_desc,

461: 'COSTING',
462: c_cost_data.cos_level_value(I),
463: c_cost_data.cos_level_value(I),
464: to_char(qpr_sr_util.get_null_pk),
465: qpr_sr_util.get_cost_type_desc,
466: to_char(qpr_sr_util.get_all_cos_pk),
467: qpr_sr_util.get_all_cos_desc,
468: d_sysdate,
469: l_user_id,

Line 466: to_char(qpr_sr_util.get_all_cos_pk),

462: c_cost_data.cos_level_value(I),
463: c_cost_data.cos_level_value(I),
464: to_char(qpr_sr_util.get_null_pk),
465: qpr_sr_util.get_cost_type_desc,
466: to_char(qpr_sr_util.get_all_cos_pk),
467: qpr_sr_util.get_all_cos_desc,
468: d_sysdate,
469: l_user_id,
470: d_sysdate,

Line 467: qpr_sr_util.get_all_cos_desc,

463: c_cost_data.cos_level_value(I),
464: to_char(qpr_sr_util.get_null_pk),
465: qpr_sr_util.get_cost_type_desc,
466: to_char(qpr_sr_util.get_all_cos_pk),
467: qpr_sr_util.get_all_cos_desc,
468: d_sysdate,
469: l_user_id,
470: d_sysdate,
471: l_user_id,

Line 528: ' from qpr_sr_cost_data_v'||qpr_sr_util.get_dblink(p_instance_id)||

524:
525: l_sql:= ' select ord_level_value, booked_date, cos_level_value, unit_cost, '||
526: ' unit_list_price, top_model_line_id, link_to_line_id, item_type_code, '||
527: ' inventory_item_id, component_code, ato_line_id , order_quantity' ||
528: ' from qpr_sr_cost_data_v'||qpr_sr_util.get_dblink(p_instance_id)||
529: ' where booked_date between :1 and :2 ' ||
530: ' and item_type_code not in (''STANDARD'',''SERVICE'')';
531:
532: open c_sales_mdl(date_from, date_to);

Line 630: to_char(qpr_sr_util.get_null_pk),

626: 'COS',
627: 'COSTING',
628: c_cost_data.cos_level_value(I),
629: c_cost_data.cos_level_value(I),
630: to_char(qpr_sr_util.get_null_pk),
631: qpr_sr_util.get_cost_type_desc,
632: to_char(qpr_sr_util.get_all_cos_pk),
633: qpr_sr_util.get_all_cos_desc,
634: d_sysdate,

Line 631: qpr_sr_util.get_cost_type_desc,

627: 'COSTING',
628: c_cost_data.cos_level_value(I),
629: c_cost_data.cos_level_value(I),
630: to_char(qpr_sr_util.get_null_pk),
631: qpr_sr_util.get_cost_type_desc,
632: to_char(qpr_sr_util.get_all_cos_pk),
633: qpr_sr_util.get_all_cos_desc,
634: d_sysdate,
635: l_user_id,

Line 632: to_char(qpr_sr_util.get_all_cos_pk),

628: c_cost_data.cos_level_value(I),
629: c_cost_data.cos_level_value(I),
630: to_char(qpr_sr_util.get_null_pk),
631: qpr_sr_util.get_cost_type_desc,
632: to_char(qpr_sr_util.get_all_cos_pk),
633: qpr_sr_util.get_all_cos_desc,
634: d_sysdate,
635: l_user_id,
636: d_sysdate,

Line 633: qpr_sr_util.get_all_cos_desc,

629: c_cost_data.cos_level_value(I),
630: to_char(qpr_sr_util.get_null_pk),
631: qpr_sr_util.get_cost_type_desc,
632: to_char(qpr_sr_util.get_all_cos_pk),
633: qpr_sr_util.get_all_cos_desc,
634: d_sysdate,
635: l_user_id,
636: d_sysdate,
637: l_user_id,

Line 706: l_cost_alloc_perc := to_number(nvl(qpr_sr_util.read_parameter(

702: close c_measures;
703: fnd_file.put_line(fnd_file.log, 'Staging complete...');
704:
705: fnd_file.put_line(fnd_file.log, 'Calculate costs for model/kit items...');
706: l_cost_alloc_perc := to_number(nvl(qpr_sr_util.read_parameter(
707: 'QPR_MODEL_COST_MRG_PERC'),0))/100;
708: handle_kit_items;
709: handle_ato_items;
710: handle_pto_items;

Line 777: ' from qpr_sr_offinv_ar_v'||qpr_sr_util.get_dblink(p_instance_id)||

773: ' ORG_ID, INVENTORY_ITEM_ID, H_REASON_CODE, L_REASON_CODE, ' ||
774: ' TRX_NUMBER || ''-'' || LINE_NUMBER,' ||
775: ' CUST_TRX_TYPE_ID, QUANTITY_ORDERED,'||
776: ' UNIT_SELLING_PRICE, EXTENDED_AMOUNT, TRX_DATE '||
777: ' from qpr_sr_offinv_ar_v'||qpr_sr_util.get_dblink(p_instance_id)||
778: ' where TRX_TYP_NAME = '||''''||p_trx_typ_name||''''||' and'||
779: -- ' TRX_TYPE = '||''''||p_trx_type||''''||' and'||
780: ' TRX_DATE between '||''''||date_from_trx||''''||' and '||''''||date_to_trx||'''';
781: if p_h_reason_code is not null then

Line 874: qpr_sr_util.get_oad_ar_cm_type_pk, --level3 val

870: c_offadj_data.level6_value(I)), --attr2:reason code
871: null,null,null, -- attr3, attr4, attr5
872: 'Rebate-'||c_offadj_data.level9_value(I), --level2 val
873: c_offadj_data.level2_value(I), --level2 desc
874: qpr_sr_util.get_oad_ar_cm_type_pk, --level3 val
875: qpr_sr_util.get_oad_ar_cm_type_desc, --level3 desc
876: qpr_sr_util.get_oad_ar_group_pk, --level4 val
877: qpr_sr_util.get_oad_ar_group_desc, --level4 desc
878: to_char(qpr_sr_util.get_all_oad_pk), --level5 (all) val

Line 875: qpr_sr_util.get_oad_ar_cm_type_desc, --level3 desc

871: null,null,null, -- attr3, attr4, attr5
872: 'Rebate-'||c_offadj_data.level9_value(I), --level2 val
873: c_offadj_data.level2_value(I), --level2 desc
874: qpr_sr_util.get_oad_ar_cm_type_pk, --level3 val
875: qpr_sr_util.get_oad_ar_cm_type_desc, --level3 desc
876: qpr_sr_util.get_oad_ar_group_pk, --level4 val
877: qpr_sr_util.get_oad_ar_group_desc, --level4 desc
878: to_char(qpr_sr_util.get_all_oad_pk), --level5 (all) val
879: qpr_sr_util.get_all_oad_desc, --level5 (all) desc

Line 876: qpr_sr_util.get_oad_ar_group_pk, --level4 val

872: 'Rebate-'||c_offadj_data.level9_value(I), --level2 val
873: c_offadj_data.level2_value(I), --level2 desc
874: qpr_sr_util.get_oad_ar_cm_type_pk, --level3 val
875: qpr_sr_util.get_oad_ar_cm_type_desc, --level3 desc
876: qpr_sr_util.get_oad_ar_group_pk, --level4 val
877: qpr_sr_util.get_oad_ar_group_desc, --level4 desc
878: to_char(qpr_sr_util.get_all_oad_pk), --level5 (all) val
879: qpr_sr_util.get_all_oad_desc, --level5 (all) desc
880: d_sysdate,

Line 877: qpr_sr_util.get_oad_ar_group_desc, --level4 desc

873: c_offadj_data.level2_value(I), --level2 desc
874: qpr_sr_util.get_oad_ar_cm_type_pk, --level3 val
875: qpr_sr_util.get_oad_ar_cm_type_desc, --level3 desc
876: qpr_sr_util.get_oad_ar_group_pk, --level4 val
877: qpr_sr_util.get_oad_ar_group_desc, --level4 desc
878: to_char(qpr_sr_util.get_all_oad_pk), --level5 (all) val
879: qpr_sr_util.get_all_oad_desc, --level5 (all) desc
880: d_sysdate,
881: l_user_id,

Line 878: to_char(qpr_sr_util.get_all_oad_pk), --level5 (all) val

874: qpr_sr_util.get_oad_ar_cm_type_pk, --level3 val
875: qpr_sr_util.get_oad_ar_cm_type_desc, --level3 desc
876: qpr_sr_util.get_oad_ar_group_pk, --level4 val
877: qpr_sr_util.get_oad_ar_group_desc, --level4 desc
878: to_char(qpr_sr_util.get_all_oad_pk), --level5 (all) val
879: qpr_sr_util.get_all_oad_desc, --level5 (all) desc
880: d_sysdate,
881: l_user_id,
882: d_sysdate,

Line 879: qpr_sr_util.get_all_oad_desc, --level5 (all) desc

875: qpr_sr_util.get_oad_ar_cm_type_desc, --level3 desc
876: qpr_sr_util.get_oad_ar_group_pk, --level4 val
877: qpr_sr_util.get_oad_ar_group_desc, --level4 desc
878: to_char(qpr_sr_util.get_all_oad_pk), --level5 (all) val
879: qpr_sr_util.get_all_oad_desc, --level5 (all) desc
880: d_sysdate,
881: l_user_id,
882: d_sysdate,
883: l_user_id,