ITMUPDMTLGVWLNG

(SQL View)
Index Back

Item Update Material Group Vw

This view is used for prompting on Material Group where the Checklist Item Update indicator in GENL_MATERIALS table is equal to "Y".

SELECT DISTINCT A.institution , D.Emplid , A.Genl_Matl_Group , A.effdt ,A.LANGUAGE_CD , A.Descr FROM PS_MATL_GRP_LNG A , PS_MATL_GRPTYP_TBL B , PS_MATL_TYPE_TBL C , PS_GENL_MATERIALS D WHERE b.institution = a.institution AND b.genl_matl_group = a.genl_matl_group AND b.genl_matl_group = d.genl_matl_group AND b.effdt = a.effdt AND C.Genl_Matl_Type = B.Genl_Matl_Type AND C.Genl_Matl_Type = D.Genl_Matl_Type AND C.Genl_Matl_Chk = 'Y' AND D.Chklst_Itm_Updt = 'Y'

  • Related Language Record for ITMUPD_MTLGR_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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    3 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group

    Prompt Table: MATL_GRP_VW

    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description