SELECT MSF.INV_ORG , MSF.ITEM , /* THIS HAS TO BE A NVL FOR PRODUCT AND INTEREST TYPES.*/ MSF.CUSTOMER , /* USUALLY THIS WILL BE NULL */ MSF.SALES_CHANNEL , MSF.SALES_REP , /* EITHER SALES REP OR SALES GROUP*/ MSF.SHIP_TO_LOC , /* USUALLY THIS WILL BE NULL */ MSF.USER_DEFINED1 , MSF.USER_DEFINED2 , MSF.PERIOD_NAME , MSF.PERIOD_START_DATE , MSF.PERIOD_END_DATE , MSF.FORECAST_AMOUNT , MSF.UPSIDE_AMOUNT , MSF.QUOTA_AMOUNT FROM MSD_SALES_FORECAST MSF
[Home] [Help]