REQ_SE_LINE_LAN

(SQL View)
 Index Back

REQ Line SES view


SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LANGUAGE_CD , A.NAME1 , A.NAME2 , A.VENDOR_NAME_SHORT , A.DESCR , C.DESCR60 , C.DESCRSHORT , D.DESCR60 , D.DESCRSHORT FROM (PS_REQ_SELINE2_LAN A LEFT OUTER JOIN PS_MANUFACT_LANG C ON C.MFG_ID = A.MFG_ID AND A.ITM_SETID = C.SETID AND A.LANGUAGE_CD = C.LANGUAGE_CD) , PS_ITM_CAT_TBL_LNG D WHERE D.CATEGORY_ID = A.CATEGORY_ID AND A.ITM_SETID = D.SETID AND A.LANGUAGE_CD = D.LANGUAGE_CD AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_ITM_CAT_TBL_LNG D1 WHERE D.SETID = D1.SETID AND D.CATEGORY_ID = D1.CATEGORY_ID AND D1.EFFDT <= %CurrentDateIn)

  • Related Language Record for REQ_SE_LINE_VW

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

    Default Value: NEXT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCR60_2 Character(60) VARCHAR2(60) NOT NULL Description
    9 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    10 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    11 DESCRSHORT2 Character(10) VARCHAR2(10) NOT NULL Short Description