TRN_FZNDSP_SRCH

(SQL View)
 Index Back

Display Target Search Record

Display Target Search Record

SELECT A.BUDGET_PERIOD , A.BUSINESS_UNIT , C.DESCR , B.DISPLAY_TARGET_ID FROM PS_BUDGET_BUS_UNIT A , PS_TRN_DSPL_TARGET B , PS_BUDGET_PERIOD C WHERE A.BUDGET_PERIOD = C.BUDGET_PERIOD AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND FROZEN_SW = 'Y'

  • Related Language Record: TN_FZNDSSCH_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period

    Prompt Table: BUDGET_PERIOD

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: TRN_FZN_BGT_BU2

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DISPLAY_TARGET_ID Character(10) VARCHAR2(10) NOT NULL Dept View ID

    Prompt Table: TRN_DSPL_TARGET