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.GMP_HORIZONTAL_PDR_PKG dependencies on GMP_PDR_ITEMS_GTMP

Line 261: gmp_pdr_items_gtmp gpi,

257: SUM(NVL(rec.old_order_quantity,0)) old_quantity,
258: sum(0) dos,
259: 0 cost
260: FROM --msc_form_query list,
261: gmp_pdr_items_gtmp gpi,
262: msc_trading_partners param,
263: -- msc_system_items msi,
264: msc_supplies rec,
265: msc_calendar_dates dates

Line 440: gmp_pdr_items_gtmp gpi,

436: 0 old_quantity,
437: 0 dos,
438: 0 cost
439: FROM -- msc_form_query list,
440: gmp_pdr_items_gtmp gpi,
441: msc_trading_partners param,
442: msc_demands mgr,
443: msc_calendar_dates dates
444: WHERE /*(arg_res_level = 1

Line 572: gmp_pdr_items_gtmp gpi,

568: SUM(DECODE(mgr.error_type, 2, mgr.forecast_MAD, 0)) old_quantity,
569: 0 dos,
570: 0 cost
571: FROM --msc_form_query list,
572: gmp_pdr_items_gtmp gpi,
573: msc_trading_partners param,
574: msc_demands mgr,
575: msc_calendar_dates dates
576: WHERE /*(arg_res_level = 1

Line 637: gmp_pdr_items_gtmp gpi,

633: 0 old_quantity,
634: 0 dos,
635: 0 cost
636: FROM --msc_form_query list,
637: gmp_pdr_items_gtmp gpi,
638: msc_available_to_promise avail
639: WHERE avail.schedule_date < last_date
640: /*AND avail.organization_id = list.number2
641: AND avail.plan_id = list.number4

Line 668: gmp_pdr_items_gtmp gpi

664: sum(safety.safety_stock_quantity * gpi.standard_cost) cost
665: FROM msc_safety_stocks safety,
666: -- msc_form_query list ,
667: -- msc_system_items item
668: gmp_pdr_items_gtmp gpi
669: WHERE safety.period_start_date <= last_date
670: /*AND safety.organization_id = list.number2
671: AND safety.sr_instance_id = list.number3
672: AND safety.plan_id = list.number4

Line 718: gmp_pdr_items_gtmp gpi

714: sum(safety.TARGET_SAFETY_STOCK * gpi.standard_cost) cost
715: FROM msc_safety_stocks safety,
716: -- msc_form_query list ,
717: -- msc_system_items item
718: gmp_pdr_items_gtmp gpi
719: WHERE safety.period_start_date <= last_date
720: /*AND safety.organization_id = list.number2
721: AND safety.sr_instance_id = list.number3
722: AND safety.plan_id = list.number4

Line 767: gmp_pdr_items_gtmp gpi

763: sum(safety.USER_DEFINED_SAFETY_STOCKS * gpi.standard_cost) cost
764: FROM msc_safety_stocks safety,
765: -- msc_form_query list,
766: -- msc_system_items item
767: gmp_pdr_items_gtmp gpi
768: WHERE safety.period_start_date <= last_date
769: /*
770: AND safety.organization_id = list.number2
771: AND safety.sr_instance_id = list.number3

Line 818: gmp_pdr_items_gtmp gpi

814: sum(safety.DEMAND_VAR_SS_PERCENT) cost
815: FROM msc_safety_stocks safety,
816: -- msc_form_query list,
817: -- msc_system_items item
818: gmp_pdr_items_gtmp gpi
819: WHERE safety.period_start_date <= last_date
820: AND safety.organization_id = gpi.organization_id
821: AND safety.sr_instance_id = G_inst_id
822: AND safety.plan_id = G_plan_id

Line 865: gmp_pdr_items_gtmp gpi

861: min(lvl.min_quantity_dos) dos,
862: 0
863: FROM msc_inventory_levels lvl,
864: -- msc_form_query list
865: gmp_pdr_items_gtmp gpi
866: WHERE lvl.inventory_date <= last_date
867: /*
868: AND lvl.organization_id = list.number2
869: AND lvl.sr_instance_id = list.number3

Line 907: gmp_pdr_items_gtmp gpi

903: max(lvl.max_quantity_dos) dos,
904: 0
905: FROM msc_inventory_levels lvl,
906: -- msc_form_query list
907: gmp_pdr_items_gtmp gpi
908: WHERE lvl.inventory_date<= last_date
909: /*
910: AND lvl.organization_id = list.number2
911: AND lvl.sr_instance_id = list.number3

Line 949: gmp_pdr_items_gtmp gpi

945: 0 dos,
946: 0
947: FROM msc_analysis_aggregate lvl,
948: -- msc_form_query list
949: gmp_pdr_items_gtmp gpi
950: WHERE lvl.period_start_date <= last_date
951: AND lvl.period_start_date >= l_bckt_start_date -1
952: AND lvl.record_type = 1
953: AND lvl.period_type = 0

Line 993: gmp_pdr_items_gtmp gpi

989: 0 dos,
990: 0
991: FROM msc_analysis_aggregate lvl,
992: -- msc_form_query list
993: gmp_pdr_items_gtmp gpi
994: WHERE lvl.period_start_date <= last_date
995: AND lvl.period_start_date >= l_bckt_start_date -1
996: AND lvl.record_type = 1
997: AND lvl.period_type = 0

Line 1289: FROM gmp_pdr_items_gtmp gpi

1285: prev_period_loop_counter NUMBER;
1286:
1287: CURSOR check_atp IS
1288: SELECT gpi.calculate_atp
1289: FROM gmp_pdr_items_gtmp gpi
1290: WHERE gpi.inventory_item_id = p_item_id
1291: AND gpi.organization_id = p_org_id;
1292:
1293: BEGIN