MATL_GRPT_VW_LN

(SQL View)
 Index Back

Rel Lang Vw - MATL_GRPTYP_VW

Related Language View of Material Group Type View This table will provide a view of all group types that are general materials.

SELECT A.INSTITUTION , A.Genl_Matl_Group , A.Genl_Matl_Type , C.LANGUAGE_CD , B.Descr FROM PS_MATL_GRPTYP_TBL A ,PS_MATL_TYPE_TBL B ,PS_MATL_TYPE_LANG C WHERE A.Effdt = ( SELECT MAX(effdt) FROM PS_MATL_GRPTYP_TBL A1 WHERE A1.Genl_Matl_Group = A.Genl_Matl_Group AND A1.Genl_Matl_Type = A.Genl_Matl_Type AND A1.Effdt <= %CurrentDateIn) AND B.Genl_Matl_Type = A.Genl_Matl_Type AND B.Genl_Matl_Type = C.Genl_Matl_Type AND C.Genl_Matl_Type = A.Genl_Matl_Type AND B.Genl_Matl_Chk = 'Y'

  • Related Language Record for MATL_GRPTYP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group
    3 GENL_MATL_TYPE Character(3) VARCHAR2(3) NOT NULL Material Type
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description