SP_BU_AC_NONLVW

(SQL View)
 Index Back

Order Capture BU Rel Language

Order Capture BU Related Language Table

SELECT BUSINESS_UNIT , LANGUAGE_CD , DESCR FROM PS_SP_BU_RO_NONLVW UNION SELECT 'ALLBU' , LANGUAGE_CD , %Substring(MESSAGE_TEXT, 1, 30) FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR = 17834 AND MESSAGE_NBR = 4052

  • Related Language Record for SP_BU_ACE_NONVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_FS

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description