GENL_MATL_VWLNG

(SQL View)
 Index Back

General Materials View

GENL_MATL_VWLNG is the related language recordfor the record GENL_MATL_VW

SELECT D.emplid , D.Genl_Eval_Nbr , D.Evaluation_Code , A.genl_matl_group , A.genl_matl_type , A.genl_matl_nbr ,A.LANGUAGE_CD , A.DESCR_EXT_ORG FROM PS_GENLMATERIALLNG A , ps_genl_evaluation D WHERE A.emplid = D.emplid AND NOT EXISTS ( SELECT 'X' FROM ps_genl_matl_eval B WHERE A.emplid = B.Emplid AND B.Evaluation_Code = D.Evaluation_Code AND B.Genl_Eval_Nbr = D.Genl_Eval_Nbr AND A.genl_matl_group = B.genl_matl_group AND A.genl_matl_type = B.genl_matl_type AND A.genl_matl_nbr = B.genl_matl_nbr)

  • Related Language Record for GENL_MATL_VW

    • # 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_EVAL_NBR Number(3,0) SMALLINT NOT NULL Evaluation Number
    3 EVALUATION_CODE Character(10) VARCHAR2(10) NOT NULL Evaluation Code
    4 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group

    Prompt Table: MATL_GRP_TBL

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

    Prompt Table: MATL_TYPE_TBL

    6 GENL_MATL_NBR Number(3,0) SMALLINT NOT NULL Material Nbr
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR_EXT_ORG Character(30) VARCHAR2(30) NOT NULL Org Name