MATL_GRPTYP_VW

(SQL View)
 Index Back

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, B.Descr from PS_MATL_GRPTYP_TBL A, PS_MATL_TYPE_TBL B 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_Chk = 'Y'

  • Related Language Record: MATL_GRPT_VW_LN

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description