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.MRP_EPI dependencies on MRP_BIS_FORECAST_WB

Line 538: DBMS_STATS.gather_table_stats('MRP','MRP_BIS_FORECAST_WB', estimate_percent

534:
535: -- bug2384395
536: -- before delete analyse mrp_bis_forecast
537: BEGIN
538: DBMS_STATS.gather_table_stats('MRP','MRP_BIS_FORECAST_WB', estimate_percent
539: => 10, degree => 2, granularity => 'GLOBAL', cascade =>TRUE);
540: EXCEPTION
541: WHEN OTHERS THEN
542: FND_FILE.put_line(fnd_file.log,'MRP_BIS_FORECAST_WB : '||sqlerrm(sqlcode));

Line 542: FND_FILE.put_line(fnd_file.log,'MRP_BIS_FORECAST_WB : '||sqlerrm(sqlcode));

538: DBMS_STATS.gather_table_stats('MRP','MRP_BIS_FORECAST_WB', estimate_percent
539: => 10, degree => 2, granularity => 'GLOBAL', cascade =>TRUE);
540: EXCEPTION
541: WHEN OTHERS THEN
542: FND_FILE.put_line(fnd_file.log,'MRP_BIS_FORECAST_WB : '||sqlerrm(sqlcode));
543: END;
544:
545: /*----------------------------------------------------------------+
546: | Each run of the concurrent program repopulates the summary |

Line 549: DELETE FROM mrp_bis_forecast_wb

545: /*----------------------------------------------------------------+
546: | Each run of the concurrent program repopulates the summary |
547: | table so delete the existing records. |
548: +----------------------------------------------------------------*/
549: DELETE FROM mrp_bis_forecast_wb
550: WHERE organization_id = p_organization_id
551: AND forecast_set between p_from_forecast and p_to_forecast
552: AND forecast_date between p_from_date and p_to_date;
553:

Line 562: 'drop index MRP_BIS_FORECAST_WB_N1',

558: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
559: application_short_name => 'MRP',
560: statement_type => AD_DDL.DROP_INDEX,
561: statement =>
562: 'drop index MRP_BIS_FORECAST_WB_N1',
563: object_name => 'MRP_BIS_FORECAST_WB');
564: --
565: EXCEPTION
566: WHEN OTHERS THEN

Line 563: object_name => 'MRP_BIS_FORECAST_WB');

559: application_short_name => 'MRP',
560: statement_type => AD_DDL.DROP_INDEX,
561: statement =>
562: 'drop index MRP_BIS_FORECAST_WB_N1',
563: object_name => 'MRP_BIS_FORECAST_WB');
564: --
565: EXCEPTION
566: WHEN OTHERS THEN
567: FND_FILE.put_line(fnd_file.log,'Drop Index 1 Error : '||SQLERRM(sqlcode));

Line 575: 'drop index MRP_BIS_FORECAST_WB_N2',

571: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
572: application_short_name => 'MRP',
573: statement_type => AD_DDL.DROP_INDEX,
574: statement =>
575: 'drop index MRP_BIS_FORECAST_WB_N2',
576: object_name => 'MRP_BIS_FORECAST_WB');
577:
578: --
579: EXCEPTION

Line 576: object_name => 'MRP_BIS_FORECAST_WB');

572: application_short_name => 'MRP',
573: statement_type => AD_DDL.DROP_INDEX,
574: statement =>
575: 'drop index MRP_BIS_FORECAST_WB_N2',
576: object_name => 'MRP_BIS_FORECAST_WB');
577:
578: --
579: EXCEPTION
580: WHEN OTHERS THEN

Line 593: INSERT INTO MRP_BIS_FORECAST_WB (

589:
590: /* 2169811 - SVAIDYAN : commented the cond. parend_demand_id is not null
591: since this will be null in mtl_demand_omoe */
592:
593: INSERT INTO MRP_BIS_FORECAST_WB (
594: organization_id,
595: organization_code,
596: organization_name,
597: forecast_set,

Line 861: 'create index MRP_BIS_FORECAST_WB_N1'

857: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
858: application_short_name => 'MRP',
859: statement_type => AD_DDL.CREATE_INDEX,
860: statement =>
861: 'create index MRP_BIS_FORECAST_WB_N1'
862: ||' on MRP_BIS_FORECAST_WB '
863: ||'(ORGANIZATION_ID, INVENTORY_ITEM_ID,FORECAST_DATE)'
864: ||' STORAGE (INITIAL 40K NEXT 2520K PCTINCREASE 50) ',
865: object_name =>'MRP_BIS_FORECAST_WB');

Line 862: ||' on MRP_BIS_FORECAST_WB '

858: application_short_name => 'MRP',
859: statement_type => AD_DDL.CREATE_INDEX,
860: statement =>
861: 'create index MRP_BIS_FORECAST_WB_N1'
862: ||' on MRP_BIS_FORECAST_WB '
863: ||'(ORGANIZATION_ID, INVENTORY_ITEM_ID,FORECAST_DATE)'
864: ||' STORAGE (INITIAL 40K NEXT 2520K PCTINCREASE 50) ',
865: object_name =>'MRP_BIS_FORECAST_WB');
866: EXCEPTION

Line 865: object_name =>'MRP_BIS_FORECAST_WB');

861: 'create index MRP_BIS_FORECAST_WB_N1'
862: ||' on MRP_BIS_FORECAST_WB '
863: ||'(ORGANIZATION_ID, INVENTORY_ITEM_ID,FORECAST_DATE)'
864: ||' STORAGE (INITIAL 40K NEXT 2520K PCTINCREASE 50) ',
865: object_name =>'MRP_BIS_FORECAST_WB');
866: EXCEPTION
867: WHEN OTHERS THEN
868: FND_FILE.put_line(fnd_file.log,'Create Index 1 Error : '||SQLERRM(sqlcode))
869: ;

Line 877: 'create index MRP_BIS_FORECAST_WB_N2'

873: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
874: application_short_name => 'MRP',
875: statement_type => AD_DDL.CREATE_INDEX,
876: statement =>
877: 'create index MRP_BIS_FORECAST_WB_N2'
878: ||' on MRP_BIS_FORECAST_WB '
879: ||'(ORGANIZATION_NAME, FORECAST_SET)'
880: ||' STORAGE (INITIAL 40K NEXT 3784K PCTINCREASE 50) ',
881: object_name =>'MRP_BIS_FORECAST_WB');

Line 878: ||' on MRP_BIS_FORECAST_WB '

874: application_short_name => 'MRP',
875: statement_type => AD_DDL.CREATE_INDEX,
876: statement =>
877: 'create index MRP_BIS_FORECAST_WB_N2'
878: ||' on MRP_BIS_FORECAST_WB '
879: ||'(ORGANIZATION_NAME, FORECAST_SET)'
880: ||' STORAGE (INITIAL 40K NEXT 3784K PCTINCREASE 50) ',
881: object_name =>'MRP_BIS_FORECAST_WB');
882: EXCEPTION

Line 881: object_name =>'MRP_BIS_FORECAST_WB');

877: 'create index MRP_BIS_FORECAST_WB_N2'
878: ||' on MRP_BIS_FORECAST_WB '
879: ||'(ORGANIZATION_NAME, FORECAST_SET)'
880: ||' STORAGE (INITIAL 40K NEXT 3784K PCTINCREASE 50) ',
881: object_name =>'MRP_BIS_FORECAST_WB');
882: EXCEPTION
883: WHEN OTHERS THEN
884: FND_FILE.put_line(fnd_file.log,'Create Index 2 Error : '||SQLERRM(sqlcode));
885: END;

Line 894: INSERT INTO MRP_BIS_FORECAST_WB (

890: | forecast records that are excluded because the join to mtl_demand |
891: | is false. |
892: +---------------------------------------------------------------------*/
893:
894: INSERT INTO MRP_BIS_FORECAST_WB (
895: organization_id,
896: organization_code,
897: organization_name,
898: forecast_set,

Line 1070: FROM mrp_bis_forecast_wb

1066: AND NVL(dates.rate_end_date,p_from_date)
1067: between p_from_date and p_to_date
1068: AND NVL(desig.disable_date,p_to_date + 1) > p_to_date /*2560013*/
1069: AND NOT EXISTS (SELECT 'x'
1070: FROM mrp_bis_forecast_wb
1071: WHERE inventory_item_id = dates.inventory_item_id
1072: AND organization_id = dates.organization_id
1073: AND forecast_set = desig.forecast_set
1074: AND DECODE(update_type,2, NVL(desig.ship_id,-1),-1)

Line 1094: INSERT INTO MRP_BIS_FORECAST_WB (

1090: md.inventory_item_id = wb.inventory_item_id Without this change, it will
1091: show the actual quantity as the sum of actual quantity of all sales orders
1092: for all items in all forecasts against each forecast. */
1093:
1094: INSERT INTO MRP_BIS_FORECAST_WB (
1095: organization_id,
1096: organization_code,
1097: organization_name,
1098: forecast_set,

Line 1206: FROM mrp_bis_forecast_wb

1202: mtl_system_items_kfv sys,
1203: mtl_parameters param,
1204: (SELECT distinct organization_id, organization_code, organization_name,
1205: update_type, forecast_set, inventory_item_id
1206: FROM mrp_bis_forecast_wb
1207: WHERE organization_id = p_organization_id
1208: AND forecast_set between p_from_forecast and p_to_forecast
1209: AND forecast_date between p_from_date and p_to_date) wb,
1210: mtl_demand_omoe md

Line 1252: FROM mrp_bis_forecast_wb

1248: AND md.organization_id = wb.organization_id
1249: AND md.inventory_item_id = wb.inventory_item_id
1250: AND md.requirement_date between p_from_date and p_to_date
1251: AND NOT EXISTS (SELECT 'x'
1252: FROM mrp_bis_forecast_wb
1253: WHERE inventory_item_id = md.inventory_item_id
1254: AND organization_id = md.organization_id
1255: AND forecast_set = wb.forecast_set
1256: AND organization_id = wb.organization_id