DP_PUBRLFCITVW2

(SQL View)
 Index Back

DP_PUBRLFCITVW2

DP_PUBRLFCITVW2

SELECT DISTINCT(A.OPRID ) , C.DP_CONFIGVIEW , A.DP_FORECASTITEM , B.DP_PUBLISHNAME , B.DP_PUBLISH_DATE , C.DP_CONFIGLEVEL , B.DP_FCITEMCAPTION FROM PS_DP_ROLEFCITMVW4 A , PS_DP_PUB_FCITEMS B , PS_DP_PUB_FCAST C WHERE A.DP_CONFIGVIEW = C.DP_CONFIGVIEW AND A.DP_CONFIGLEVEL = C.DP_CONFIGLEVEL AND B.DP_PUBLISHNAME = C.DP_PUBLISHNAME AND B.DP_PUBLISH_DATE = C.DP_PUBLISH_DATE AND A.DP_FORECASTITEM = B.DP_FORECASTITEM

  • Parent record: DP_PUB_FCAST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

    Prompt Table: %EDITTABLE

    3 DP_FORECASTITEM Character(120) VARCHAR2(120) NOT NULL DP_FORECASTITEM
    4 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
    5 DP_PUBLISH_DATE Date(10) DATE NOT NULL DP_PUBLISH_DATE
    6 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
    7 DP_FCITEMCAPTION Character(40) VARCHAR2(40) NOT NULL DP_FCITEMCAPTION