DBA Data[Home] [Help]

APPS.MTL_SAFETY_STOCKS_PKG dependencies on MTL_ITEM_CATEGORIES

Line 82: MTL_ITEM_CATEGORIES C

78:
79: cursor ITEM2_cur IS
80: SELECT DISTINCT F.INVENTORY_ITEM_ID
81: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F,
82: MTL_ITEM_CATEGORIES C
83: WHERE D.ORGANIZATION_ID = X_ORGANIZATION_ID AND
84: D.FORECAST_DESIGNATOR = X_FORECAST_NAME AND
85: D.ORGANIZATION_ID = F.ORGANIZATION_ID AND
86: D.FORECAST_DESIGNATOR = F.FORECAST_DESIGNATOR AND

Line 172: AND EXISTS ( SELECT 1 FROM MTL_ITEM_CATEGORIES C

168: ELSE
169: DELETE FROM MTL_SAFETY_STOCKS M
170: WHERE ORGANIZATION_ID = X_ORGANIZATION_ID
171: AND FORECAST_DESIGNATOR = X_FORECAST_NAME
172: AND EXISTS ( SELECT 1 FROM MTL_ITEM_CATEGORIES C
173: WHERE C.ORGANIZATION_ID = M.ORGANIZATION_ID
174: AND C.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
175: AND C.CATEGORY_SET_ID = X_CATEGORY_SET_ID
176: AND C.CATEGORY_ID = X_CATEGORY_ID

Line 180: MTL_ITEM_CATEGORIES C

176: AND C.CATEGORY_ID = X_CATEGORY_ID
177: AND C.ORGANIZATION_ID = X_ORGANIZATION_ID )
178: AND INVENTORY_ITEM_ID NOT IN ( SELECT DISTINCT F.INVENTORY_ITEM_ID
179: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F,
180: MTL_ITEM_CATEGORIES C
181: WHERE D.ORGANIZATION_ID = X_ORGANIZATION_ID
182: AND D.FORECAST_DESIGNATOR = X_FORECAST_NAME
183: AND D.ORGANIZATION_ID = F.ORGANIZATION_ID
184: AND D.FORECAST_DESIGNATOR = F.FORECAST_DESIGNATOR