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 273: gmp_pdr_items_gtmp gpi,

269: SUM(NVL(rec.old_order_quantity,0)) old_quantity,
270: sum(0) dos,
271: 0 cost
272: FROM --msc_form_query list,
273: gmp_pdr_items_gtmp gpi,
274: msc_trading_partners param,
275: -- msc_system_items msi,
276: msc_supplies rec,
277: msc_calendar_dates dates

Line 451: gmp_pdr_items_gtmp gpi,

447: 0 old_quantity,
448: 0 dos,
449: 0 cost
450: FROM -- msc_form_query list,
451: gmp_pdr_items_gtmp gpi,
452: msc_trading_partners param,
453: msc_demands mgr,
454: msc_calendar_dates dates
455: WHERE /*(arg_res_level = 1

Line 585: gmp_pdr_items_gtmp gpi,

581: SUM(DECODE(mgr.error_type, 2, mgr.forecast_MAD, 0)) old_quantity,
582: 0 dos,
583: 0 cost
584: FROM --msc_form_query list,
585: gmp_pdr_items_gtmp gpi,
586: msc_trading_partners param,
587: msc_demands mgr,
588: msc_calendar_dates dates
589: WHERE /*(arg_res_level = 1

Line 650: gmp_pdr_items_gtmp gpi,

646: 0 old_quantity,
647: 0 dos,
648: 0 cost
649: FROM --msc_form_query list,
650: gmp_pdr_items_gtmp gpi,
651: msc_available_to_promise avail
652: WHERE avail.schedule_date < last_date
653: /*AND avail.organization_id = list.number2
654: AND avail.plan_id = list.number4

Line 681: gmp_pdr_items_gtmp gpi

677: sum(safety.safety_stock_quantity * gpi.standard_cost) cost
678: FROM msc_safety_stocks safety,
679: -- msc_form_query list ,
680: -- msc_system_items item
681: gmp_pdr_items_gtmp gpi
682: WHERE safety.period_start_date <= last_date
683: /*AND safety.organization_id = list.number2
684: AND safety.sr_instance_id = list.number3
685: AND safety.plan_id = list.number4

Line 731: gmp_pdr_items_gtmp gpi

727: sum(safety.TARGET_SAFETY_STOCK * gpi.standard_cost) cost
728: FROM msc_safety_stocks safety,
729: -- msc_form_query list ,
730: -- msc_system_items item
731: gmp_pdr_items_gtmp gpi
732: WHERE safety.period_start_date <= last_date
733: /*AND safety.organization_id = list.number2
734: AND safety.sr_instance_id = list.number3
735: AND safety.plan_id = list.number4

Line 780: gmp_pdr_items_gtmp gpi

776: sum(safety.USER_DEFINED_SAFETY_STOCKS * gpi.standard_cost) cost
777: FROM msc_safety_stocks safety,
778: -- msc_form_query list,
779: -- msc_system_items item
780: gmp_pdr_items_gtmp gpi
781: WHERE safety.period_start_date <= last_date
782: /*
783: AND safety.organization_id = list.number2
784: AND safety.sr_instance_id = list.number3

Line 831: gmp_pdr_items_gtmp gpi

827: sum(safety.DEMAND_VAR_SS_PERCENT) cost
828: FROM msc_safety_stocks safety,
829: -- msc_form_query list,
830: -- msc_system_items item
831: gmp_pdr_items_gtmp gpi
832: WHERE safety.period_start_date <= last_date
833: AND safety.organization_id = gpi.organization_id
834: AND safety.sr_instance_id = G_inst_id
835: AND safety.plan_id = G_plan_id

Line 878: gmp_pdr_items_gtmp gpi

874: min(lvl.min_quantity_dos) dos,
875: 0
876: FROM msc_inventory_levels lvl,
877: -- msc_form_query list
878: gmp_pdr_items_gtmp gpi
879: WHERE lvl.inventory_date <= last_date
880: /*
881: AND lvl.organization_id = list.number2
882: AND lvl.sr_instance_id = list.number3

Line 920: gmp_pdr_items_gtmp gpi

916: max(lvl.max_quantity_dos) dos,
917: 0
918: FROM msc_inventory_levels lvl,
919: -- msc_form_query list
920: gmp_pdr_items_gtmp gpi
921: WHERE lvl.inventory_date<= last_date
922: /*
923: AND lvl.organization_id = list.number2
924: AND lvl.sr_instance_id = list.number3

Line 962: gmp_pdr_items_gtmp gpi

958: 0 dos,
959: 0
960: FROM msc_analysis_aggregate lvl,
961: -- msc_form_query list
962: gmp_pdr_items_gtmp gpi
963: WHERE lvl.period_start_date <= last_date
964: AND lvl.period_start_date >= l_bckt_start_date -1
965: AND lvl.record_type = 1
966: AND lvl.period_type = 0

Line 1006: gmp_pdr_items_gtmp gpi

1002: 0 dos,
1003: 0
1004: FROM msc_analysis_aggregate lvl,
1005: -- msc_form_query list
1006: gmp_pdr_items_gtmp gpi
1007: WHERE lvl.period_start_date <= last_date
1008: AND lvl.period_start_date >= l_bckt_start_date -1
1009: AND lvl.record_type = 1
1010: AND lvl.period_type = 0

Line 1307: FROM gmp_pdr_items_gtmp gpi

1303: prev_period_loop_counter NUMBER;
1304:
1305: CURSOR check_atp IS
1306: SELECT gpi.calculate_atp
1307: FROM gmp_pdr_items_gtmp gpi
1308: WHERE gpi.inventory_item_id = p_item_id
1309: AND gpi.organization_id = p_org_id;
1310:
1311: BEGIN