WM_EPL_PRT_LVW3

(SQL View)
Index Back

WM EPL Parts RL Vw #3 (WO/JRL)

Work Management EPL Parts View -- version #3, related language view

SELECT A.SETID , A.EPL_TMPL_ID , B.INV_ITEM_ID , C.LANGUAGE_CD , C.DESCR254_MIXED FROM PS_AM_EPL_MASTR A , PS_AM_EPL_PARTS B , PS_AM_EPL_PARTS_LG C WHERE A.EPL_TMPL_ID = B.EPL_TMPL_ID AND A.SETID = B.SETID AND B.ASSET_FLG <> 'Y' AND B.SETID = C.SETID AND B.EPL_TMPL_ID = C.EPL_TMPL_ID AND B.SEQNBR = C.SEQNBR

  • Related Language Record for WM_EPL_PART_VW3
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 EPL_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Parts List Template
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: INV_ITEMS

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description