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 MTL_DEMAND_OMOE

Line 591: since this will be null in mtl_demand_omoe */

587: | forecast then it shows the orders against that forecast |
588: +----------------------------------------------------------------*/
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,

Line 1088: since this will be null in mtl_demand_omoe. Also added the select of

1084: | Insert a record for orders that were not forecast |
1085: +-------------------------------------------------------------------*/
1086:
1087: /* 2169811 - SVAIDYAN : commented the cond. parend_demand_id is not null
1088: since this will be null in mtl_demand_omoe. Also added the select of
1089: inventory_item_id for wb and the cond.
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. */

Line 1210: mtl_demand_omoe md

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
1211: WHERE PART.party_id (+)= CA.party_id
1212: AND ar.lookup_type(+) = 'CUSTOMER_CLASS'
1213: AND ar.lookup_code(+) = CA.customer_class_code
1214: -- bug2384395