GS1_MST_ITM_PMT

(SQL View)
 Index Back

Item Master Prompt View

SetId item promt view that will bring back all Items with status of Active, Hold, Discontinue, and Inactive

SELECT DISTINCT A.SETID , A.inv_item_id , A.descr , A.inv_item_group , A.inv_prod_fam_cd , B.ITM_ID_VNDR ,C.CATEGORY_CD ,E.MFG_ID ,E.MFG_ITM_ID , F.UPN_ID , A.SERIAL_CONTROL , A.LOT_CONTROL FROM PS_MASTER_ITEM_TBL A LEFT OUTER JOIN PS_ITM_VENDOR B ON (A.SETID =B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID) LEFT OUTER JOIN PS_ITM_CAT_VW C ON (A.SETID =C.SETID AND A.CATEGORY_ID = C.CATEGORY_ID ) LEFT OUTER JOIN PS_ITEM_MFG E ON (A.SETID = E.SETID AND A.INV_ITEM_ID = E.INV_ITEM_ID ) LEFT OUTER JOIN PS_ITEM_MFG_UPN_FS F ON (E.SETID = F.SETID AND E.INV_ITEM_ID = F.INV_ITEM_ID AND E.MFG_ID =F.MFG_ID AND E.MFG_ITM_ID = F.MFG_ITM_ID AND F.UPN_TYPE_CD = 'GTIN') WHERE A.inventory_item = 'Y' AND A.itm_status_current IN ('1','2','3','4')

  • Related Language Record: MST_ITM_PRT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: MST_ITM_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

    Prompt Table: INV_ITEM_GROUP

    5 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

    Prompt Table: INV_ITEM_FAM

    6 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    7 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
    8 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MFG_VW

    9 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

    Prompt Table: ITEM_MFG_ID_VW

    10 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number

    Prompt Table: GS1_IN_UPN_VW

    11 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    12 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y