MST_ITM_PRT_LVW

(SQL View)
 Index Back

Item Master Prompt View

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

SELECT m.setid , m.inv_item_id , e.language_cd , e.descr FROM PS_MASTER_ITEM_TBL m , ps_master_itm_lang e WHERE e.setid = m.setid AND m.inv_item_id = e.inv_item_id AND m.inventory_item = 'Y' AND m.itm_status_current IN ('1','2','3','4')

  • Related Language Record for GS1_MST_ITM_PMT MST_ITM_PRP6_VW MST_ITM_PRPT_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description