View: MRPFV_FORECASTS

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

View Text

SELECT PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, DE.FORECAST_DESIGNATOR FORECAST_NAME
, DE.DESCRIPTION DESCRIPTION
, DE.FORECAST_SET FORECAST_SET_NAME
, DE.DISABLE_DATE END_EFFECTIVE_DATE
, DE.DEMAND_CLASS DEMAND_CLASS
, CU.CUSTOMER_NAME CUSTOMER_NAME
, CU.CUSTOMER_NUMBER CUSTOMER_NUMBER
, AD1.ADDRESS1 SHIP_ADDRESS
, AD2.ADDRESS1 BILL_ADDRESS
, '_DF:MRP:MRPFFCFN2:DE'
, 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
, RA_CUSTOMERS CU
, RA_SITE_USES_ALL SI1
, RA_ADDRESSES_ALL AD1
, RA_SITE_USES_ALL SI2
, RA_ADDRESSES_ALL AD2
, MRP_FORECAST_DESIGNATORS DE
WHERE DE.FORECAST_SET IS NOT NULL
AND DE.CUSTOMER_ID = CU.CUSTOMER_ID(+)
AND DE.BILL_ID = SI1.SITE_USE_ID(+)
AND SI1.ADDRESS_ID = AD1.ADDRESS_ID(+)
AND DE.SHIP_ID = SI2.SITE_USE_ID(+)
AND SI2.ADDRESS_ID = AD2.ADDRESS_ID(+)
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