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.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_FORM_QUERY

Line 412: FROM msc_form_query list,

408: rec.daily_rate))) new_quantity,
409: SUM(NVL(rec.old_order_quantity,0)) old_quantity,
410: sum(0) dos,
411: 0 cost
412: FROM msc_form_query list,
413: msc_trading_partners param,
414: msc_system_items msi,
415: msc_supplies rec,
416: msc_calendar_dates dates

Line 602: FROM msc_form_query list,

598: null)) ,1) ,1)) new_quantity,
599: 0 old_quantity,
600: 0 dos,
601: 0 cost
602: FROM msc_form_query list,
603: msc_trading_partners param,
604: msc_demands mgr,
605: msc_calendar_dates dates
606: WHERE (arg_res_level = 1

Line 738: FROM msc_form_query list,

734: DECODE(SUM (NVL(mgr.using_requirement_quantity, 1)) ,0 ,1 ,
735: SUM (NVL(mgr.using_requirement_quantity, 1))) old_quantity,
736: 0 dos,
737: 0 cost
738: FROM msc_form_query list,
739: msc_trading_partners param,
740: msc_demands mgr,
741: msc_calendar_dates dates
742: WHERE (arg_res_level = 1

Line 791: FROM msc_form_query list,

787: avail.quantity_available new_quantity,
788: 0 old_quantity,
789: 0 dos,
790: 0 cost
791: FROM msc_form_query list,
792: msc_available_to_promise avail
793: WHERE avail.schedule_date < last_date
794: AND avail.organization_id = list.number2
795: AND avail.plan_id = list.number4

Line 812: msc_form_query list ,

808: safety.organization_id old_quantity,
809: sum(safety.achieved_days_of_supply) dos,
810: sum(safety.safety_stock_quantity * item.standard_cost) cost
811: FROM msc_safety_stocks safety,
812: msc_form_query list ,
813: msc_system_items item
814: WHERE safety.period_start_date <= last_date
815: AND safety.organization_id = list.number2
816: AND safety.sr_instance_id = list.number3

Line 850: msc_form_query list ,

846: sum(safety.TOTAL_UNPOOLED_SAFETY_STOCK) old_quantity,
847: sum(safety.target_days_of_supply) dos,
848: sum(safety.TARGET_SAFETY_STOCK * item.standard_cost) cost
849: FROM msc_safety_stocks safety,
850: msc_form_query list ,
851: msc_system_items item
852: WHERE safety.period_start_date <= last_date
853: AND safety.organization_id = list.number2
854: AND safety.sr_instance_id = list.number3

Line 887: msc_form_query list,

883: sum(0) old_quantity,
884: sum(safety.user_defined_dos) dos,
885: sum(safety.USER_DEFINED_SAFETY_STOCKS * item.standard_cost) cost
886: FROM msc_safety_stocks safety,
887: msc_form_query list,
888: msc_system_items item
889: WHERE safety.period_start_date <= last_date
890: AND safety.organization_id = list.number2
891: AND safety.sr_instance_id = list.number3

Line 924: msc_form_query list,

920: sum(safety.SUP_LTVAR_SS_PERCENT) old_quantity,
921: sum(safety.TRANSIT_LTVAR_SS_PERCENT) dos,
922: sum(safety.DEMAND_VAR_SS_PERCENT) cost
923: FROM msc_safety_stocks safety,
924: msc_form_query list,
925: msc_system_items item
926: WHERE safety.period_start_date <= last_date
927: AND safety.organization_id = list.number2
928: AND safety.sr_instance_id = list.number3

Line 960: msc_form_query list

956: min(0) old_quantity,
957: min(lvl.min_quantity_dos) dos,
958: 0
959: FROM msc_inventory_levels lvl,
960: msc_form_query list
961: WHERE lvl.inventory_date <= last_date
962: AND lvl.organization_id = list.number2
963: AND lvl.sr_instance_id = list.number3
964: AND lvl.plan_id = list.number4

Line 988: msc_form_query list

984: max(0) old_quantity,
985: max(lvl.max_quantity_dos) dos,
986: 0
987: FROM msc_inventory_levels lvl,
988: msc_form_query list
989: WHERE lvl.inventory_date<= last_date
990: AND lvl.organization_id = list.number2
991: AND lvl.sr_instance_id = list.number3
992: AND lvl.plan_id = list.number4

Line 1016: msc_form_query list,

1012: 0 old_quantity,
1013: 0 dos,
1014: 0
1015: FROM msc_analysis_aggregate lvl,
1016: msc_form_query list,
1017: msc_plan_buckets mpb
1018: WHERE lvl.record_type = 3
1019: AND lvl.period_type = 1
1020: AND lvl.plan_id = list.number4

Line 1050: msc_form_query list,

1046: 0 old_quantity,
1047: 0 dos,
1048: 0
1049: FROM msc_analysis_aggregate lvl,
1050: msc_form_query list,
1051: msc_plan_buckets mpb
1052: WHERE lvl.record_type = 3
1053: AND lvl.period_type = 1
1054: AND lvl.plan_id = list.number4

Line 1083: FROM msc_form_query list

1079: 0,
1080: 0,
1081: 0,
1082: 0
1083: FROM msc_form_query list
1084: WHERE list.query_id = item_list_id
1085: ORDER BY
1086: 1, 2, 6, 4;
1087:

Line 1306: msc_form_query mfq

1302:
1303: cursor check_atp is
1304: SELECT msi.calculate_atp
1305: FROM msc_system_items msi,
1306: msc_form_query mfq
1307: WHERE msi.inventory_item_id = mfq.number1
1308: AND msi.organization_id = mfq.number2
1309: AND msi.plan_id = arg_plan_id
1310: AND msi.sr_instance_id = mfq.number3

Line 2927: sql_stmt1 := 'INSERT INTO msc_form_query ( '||

2923: end if; -- if p_pf =-2
2924:
2925: -- dbms_output.put_line(' before inserting into temp table ');
2926:
2927: sql_stmt1 := 'INSERT INTO msc_form_query ( '||
2928: 'query_id, '||
2929: 'last_update_date, '||
2930: 'last_updated_by, '||
2931: 'creation_date, '||

Line 3213: FROM msc_form_query

3209: l_filter varchar2(255);
3210:
3211: CURSOR TRANS_C IS
3212: SELECT number1
3213: FROM msc_form_query
3214: WHERE query_id = l_query_id;
3215:
3216: CURSOR plan_start_c IS
3217: SELECT curr_start_date,

Line 3237: from msc_form_query

3233: l_dock_date_prof number := nvl(FND_PROFILE.Value('MSC_PO_DOCK_DATE_CALC_PREF'),1);
3234:
3235: cursor item_record is
3236: select distinct number2,number1
3237: from msc_form_query
3238: where query_id = p_item_query_id
3239: and number5 = p_item_id
3240: and number6 = p_org_id
3241: and number3 = p_inst_id ;

Line 3247: from msc_form_query

3243: v_item_id number;
3244:
3245: cursor item_supplier_record is
3246: select distinct number1,number8
3247: from msc_form_query
3248: where query_id = p_item_query_id;
3249:
3250:
3251: req_item_id NUMBER;

Line 3276: SELECT msc_form_query_s.nextval

3272: ''') OR (trunc(nvl(firm_date,new_due_date)) <='''||
3273: p_end_date|| ''' AND trunc(last_unit_completion_date) >= '''||
3274: p_start_date||'''))';/*End for bug 12746680 */
3275:
3276: SELECT msc_form_query_s.nextval
3277: INTO l_query_id
3278: FROM dual;
3279:
3280: --< bug5449978--if plan is drp or unconstrained ascp or any plan where enforce_supplier capacity constraints is off, fallback to msc_supplies

Line 3299: sql_stmt := 'INSERT INTO msc_form_query ( '||

3295: l_optimized_plan := 1;
3296: ELSE
3297: l_optimized_plan := 0;
3298: END IF;
3299: sql_stmt := 'INSERT INTO msc_form_query ( '||
3300: 'query_id, '||
3301: 'last_update_date, '||
3302: 'last_updated_by, '||
3303: 'creation_date, '||

Line 3556: -- need to get the real item_id, org_id from msc_form_query

3552: CLOSE item_supplier_record;
3553:
3554:
3555: ELSE -- an item
3556: -- need to get the real item_id, org_id from msc_form_query
3557:
3558: sql_stmt_1 := sql_stmt;
3559:
3560: open item_record;