RSF_FCFLT_BU_LN

(SQL View)
 Index Back

Forecast Filter Bus Unit VW


SELECT DISTINCT D.FORECAST_ID , D.TIMEFRAME_PERIOD , D.FORECAST_CATEGORY , D.BUSINESS_UNIT , L.LANGUAGE_CD , BU.DESCR FROM PS_RSF_FCAST_DTL D , PS_BUS_UNIT_TBL_FS BU , PS_BUS_UNIT_LANG L WHERE D.BUSINESS_UNIT = BU.BUSINESS_UNIT AND D.BUSINESS_UNIT = L.BUSINESS_UNIT AND BU.BUSINESS_UNIT = L.BUSINESS_UNIT AND D.BUSINESS_UNIT <> ' '

  • Related Language Record for RSF_FCFLT_BU_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORECAST_ID Character(15) VARCHAR2(15) NOT NULL Forecast Name
    2 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
    3 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
    R=Revenue Forecast
    S=Shadow Forecast
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description