View: MRPBV_FORECASTS

Product:	MRP - Master Scheduling/MRP
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MRPBV_FORECASTS

View Text

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, DE.FORECAST_DESIGNATOR
, DE.DESCRIPTION
, DE.DISABLE_DATE
, DE.FORECAST_SET
, DE.DEMAND_CLASS
, DE.ORGANIZATION_ID
, DE.CUSTOMER_ID
, DE.SHIP_ID
, DE.BILL_ID
, DE.LAST_UPDATE_DATE
, DE.LAST_UPDATED_BY
, DE.CREATION_DATE
, DE.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_FORECAST_DESIGNATORS DE
WHERE DE.FORECAST_SET IS NOT NULL
AND DE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND DE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns