DP_PUBFCIC2VW

(SQL View)
 Index Back

DP_PUBRLFCITMVW

DP_PUBRLFCITMVW

SELECT DISTINCT A.OPRID , B.DP_PUBLISHNAME , D.DP_CONFIGVIEW , B.ITEM_FIELD_C2 FROM PS_DP_ROLEFCITMVW4 A , PS_DP_PUB_FCITEMS B , PS_DP_PUB_FCAST D WHERE A.DP_CONFIGVIEW = D.DP_CONFIGVIEW AND A.DP_CONFIGLEVEL = D.DP_CONFIGLEVEL AND B.DP_PUBLISHNAME = D.DP_PUBLISHNAME AND B.DP_PUBLISH_DATE = D.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_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
    3 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

    Prompt Table: %EDITTABLE

    4 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2