SP_BURCHDLNONVW

(SQL View)
 Index Back

LNG for SS HelpDesk BU's

Language view for Self-Service Help Desk Business Units. This View does not consider Market as key. This is wrote to handle Search Solution Component. Since Search Solution is not Verticalizised this is needed. SVC002 - 6/28/2012 - ADDED RC_CASE_SS

SELECT A.BUSINESS_UNIT , C.LANGUAGE_CD , A.RC_DESCR_SS FROM PS_BUS_UNITTBL_RCL A , PS_BUS_UNIT_RC_DEF B , PS_BUS_UNIT_LANG C , PS_BUS_UNIT_TBL_RC D WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND (B.PNLGRPNAME = 'RC_CASE_HD_SS_RPT' OR B.PNLGRPNAME = 'RC_CASE_SS') AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BU_STATUS = '1' AND C.LANGUAGE_CD = A.LANGUAGE_CD

  • Related Language Record for SP_BURCHD_NONVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages