APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on GMP_HORIZONTAL_PDR_GTMP

Line 395: -- INSERT INTO horizontal_pdr_gtmp SELECT * FROM gmp_horizontal_pdr_gtmp;

391: gmp_horizontal_pdr_pkg.populate_horizontal_plan (G_inst_id, G_org_id, G_plan_id,
392: G_day_bckt_cutoff_dt, G_week_bckt_cutoff_dt, G_period_bucket, G_incl_items_no_activity);
393:
394: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After gmp_horizontal_pdr_pkg.populate_horizontal_plan ');
395: -- INSERT INTO horizontal_pdr_gtmp SELECT * FROM gmp_horizontal_pdr_gtmp;
396:
397: SELECT count(*) into Horiz_details_count FROM gmp_horizontal_pdr_gtmp;
398: gmp_debug_message(' Horiz_details_count = '|| Horiz_details_count );
399:

Line 397: SELECT count(*) into Horiz_details_count FROM gmp_horizontal_pdr_gtmp;

393:
394: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After gmp_horizontal_pdr_pkg.populate_horizontal_plan ');
395: -- INSERT INTO horizontal_pdr_gtmp SELECT * FROM gmp_horizontal_pdr_gtmp;
396:
397: SELECT count(*) into Horiz_details_count FROM gmp_horizontal_pdr_gtmp;
398: gmp_debug_message(' Horiz_details_count = '|| Horiz_details_count );
399:
400: ELSE
401:

Line 788: ' gmp_horizontal_pdr_gtmp ghp ) ';

784: -- ' ghp.quantity43 , '||
785: -- ' ghp.quantity44 , '||
786: -- ' ghp.quantity45 '||
787: ' FROM '||
788: ' gmp_horizontal_pdr_gtmp ghp ) ';
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_exception_stmt '||sqlerrm);

Line 1430: G_horiz_pdr_stmt := G_horiz_pdr_stmt || ' , (select distinct inventory_item_id from gmp_horizontal_pdr_gtmp ) gtmp '||

1426: G_horiz_pdr_stmt := G_horiz_pdr_stmt || ' FROM gmp_pdr_items_gtmp gpi ';
1427:
1428: -- Bug: 8486531
1429: IF (G_incl_items_no_activity = 2 )THEN
1430: G_horiz_pdr_stmt := G_horiz_pdr_stmt || ' , (select distinct inventory_item_id from gmp_horizontal_pdr_gtmp ) gtmp '||
1431: ' where gpi.inventory_item_id = gtmp.inventory_item_id ';
1432: END IF;
1433:
1434: IF G_fsort IS NOT NULL THEN