WM_EPL_PART_VW3

(SQL View)
 Index Back

WM EPL Parts View #3 (WO/JRL)

Work Management EPL Parts View -- version #3 to support EPL parts selection for lookup from both WO component and JRL Task Template; excludes items with Asset Flag set to "Y"

SELECT A.SETID , A.EPL_TMPL_ID ,B.INV_ITEM_ID , B.DESCR254_MIXED , B.SUPPLIER_REFERENCE , B.UNIT_OF_MEASURE , B.QUANTITY , 'N' FROM PS_AM_EPL_MASTR A , PS_AM_EPL_PARTS B WHERE A.EPL_TMPL_ID = B.EPL_TMPL_ID AND A.SETID = B.SETID AND B.ASSET_FLG <> 'Y'

  • Related Language Record: WM_EPL_PRT_LVW3

    • # 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 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    5 SUPPLIER_REFERENCE Character(20) VARCHAR2(20) NOT NULL Supplier Reference
    6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    7 QTY_REQUIRED Signed Number(17,4) DECIMAL(15,4) NOT NULL Work Order quantity required
    8 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
    N=No
    Y=Yes

    Default Value: N