VIEW: APPS.MRPBV_FORECASTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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