GVT_WIPSTS1_LNG

(SQL View)
 Index Back

WIP Status Vw for COM/COR sts


SELECT A.GVT_WIP_RECORD , A.GVT_WIP_STATUS , AL.LANGUAGE_CD , AL.DESCR FROM PS_GVT_WIP_STATUS A , PS_GVT_WIP_STA_LNG AL WHERE A.GVT_STATUS_TYPE IN ('COM', 'COR') AND A.GVT_WIP_RECORD = AL.GVT_WIP_RECORD AND A.GVT_WIP_STATUS = AL.GVT_WIP_STATUS

  • Related Language Record for GVT_WIP_STS_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_WIP_RECORD Character(25) VARCHAR2(25) NOT NULL Transaction
    2 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description