CP_PRDNITEM_VW1

(SQL View)
 Index Back

CP Ref Items for Mfg Config

View of bu_items_inv, master_item_tbl, set_cntrl_rec

SELECT a.business_unit , a.inv_item_id , b.descr60 FROM ps_bu_items_inv a , PS_MASTER_ITEM_TBL b , ps_set_cntrl_rec c WHERE a.business_unit = c.setcntrlvalue AND a.inv_item_id = b.inv_item_id AND c.recname = 'MASTER_ITEM_TBL' AND b.setid = c.setid AND b.itm_status_current = '1' AND a.inventory_item = 'Y' AND a.non_own_flag = 'N' AND a.staged_date_flag = 'N'

  • Related Language Record: CP_PRDITMVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 REF_BOM_ITEM Character(18) VARCHAR2(18) NOT NULL Reference BOM Item
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description