SF_PA_NOITM_VW

(SQL View)
 Index Back

Production Area/Item No ID VW

8/13/2014 : Created a new record for prompt in production history page.

SELECT DISTINCT a.business_unit , a.prdn_area_code , a.inv_item_id , b.descr FROM ps_sf_prdn_area_it a ,ps_sf_prdnid_headr c , PS_MASTER_ITEM_TBL b , ps_set_cntrl_rec d WHERE a.ma_prdn_id_flg = 'Y' AND b.setid = d.setid AND d.recname = 'MASTER_ITEM_TBL' AND d.setcntrlvalue = a.business_unit AND b.inv_item_id = a.inv_item_id AND a.business_unit = C.business_unit AND a.prdn_area_code = C.prdn_area_code AND a.inv_item_id = C.inv_item_id AND C.PROD_STATUS < '90' AND c.prod_status > '20'

  • Related Language Record: SF_PA_NITM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description