DBA Data[Home] [Help]

APPS.MTL_SAFETY_STOCKS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 71: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F, MTL_SYSTEM_ITEMS MSI

67:
68: cursor ITEM1_cur IS
69: --Bug#2713829, also selected MRP_SAFETY_STOCK_PERCENT from MSI.
70: SELECT DISTINCT F.INVENTORY_ITEM_ID, MSI.MRP_SAFETY_STOCK_PERCENT
71: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F, MTL_SYSTEM_ITEMS MSI
72: WHERE D.ORGANIZATION_ID = X_ORGANIZATION_ID AND
73: D.FORECAST_DESIGNATOR = X_FORECAST_NAME AND
74: D.ORGANIZATION_ID = F.ORGANIZATION_ID AND
75: D.FORECAST_DESIGNATOR = F.FORECAST_DESIGNATOR AND

Line 229: --from mtl_system_items.

225: println('Org id = '||x_organization_id);
226: println('effectivity date ='||x_start_date);
227: ELSE
228: --Bug#2713829.If ss_prcnt is not defined at the concurrent program, then obtain it
229: --from mtl_system_items.
230: IF l_prcnt_level = 2 THEN
231: ss_prcnt := nvl(item.MRP_SAFETY_STOCK_PERCENT,0);
232: END IF;
233: Main(X_ORGANIZATION_ID, item.INVENTORY_ITEM_ID,