ITMUPD_MTLTP_VW

(SQL View)
 Index Back

Item Update Material Type View

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

SELECT DISTINCT C.EmplID , A.Genl_Matl_Group , A.Genl_Matl_Type , B.Descr FROM PS_MATL_GRPTYP_TBL A , PS_MATL_TYPE_TBL B , PS_GENL_MATERIALS 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 A.Genl_Matl_Group = C.Genl_Matl_Group AND B.Genl_Matl_Chk = 'Y' AND C.Chklst_Itm_Updt = 'Y'

  • Related Language Record: ITMUPDMTLPVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

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

    Prompt Table: MATL_GRP_VW

    3 GENL_MATL_TYPE Character(3) VARCHAR2(3) NOT NULL Material Type

    Prompt Table: MATL_GRPTYP_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description