BUSINESS_UNITPRDN_AREA_CODEINV_ITEM_IDSF_PA_IT_ID_VW(SQL View) |
Index Back |
|---|---|
Production Area/Item MA ID Vw12/28/98 EWB CN#EN800-4.0: Add distinct since there are now multiple rows for same item in one area. 02/19/98 Lee: added related language view SF_PA_IT_ID_LVW. 2/19/98 RS : RL View Type C2 |
| Select distinct a.business_unit, a.prdn_area_code, a.inv_item_id, b.descr from ps_sf_prdn_area_it a, PS_MASTER_ITEM_TBL b, ps_set_cntrl_rec c where a.ma_prdn_id_flg = 'Y' and b.setid= c.setid and c.recname = 'MASTER_ITEM_TBL' and c.setcntrlvalue = a.business_unit and b.inv_item_id=a.inv_item_id |
| # | 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 |