PL_ITEMSRCH_VW

(SQL View)
 Index Back

PL Item search view

3/2000 - view used in planning item search panel 6/30/00 lee/rakesh - added rlv

SELECT a.setid , b.business_unit , a.inv_item_id , a.descr , b.planner_cd , a.inv_item_group , a.inv_prod_fam_cd , a.category_id , c.planned_by FROM PS_MASTER_ITEM_TBL a , ps_bu_items_inv b , ps_pl_item_attrib c , ps_set_cntrl_rec d WHERE a.inv_item_id = b.inv_item_id AND b.inv_item_id = c.inv_item_id AND b.business_unit = c.business_unit AND d.recname='MASTER_ITEM_TBL' AND d.setid=a.setid AND d.setcntrlvalue=b.business_unit

  • Related Language Record: PL_ITEMSRCH_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code
    6 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    7 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
    8 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    9 PLANNED_BY Character(1) VARCHAR2(1) NOT NULL Planned By
    1=Distribution Planning
    2=Master Planning
    3=Material Planning
    4=Not Planned