BUSINESS_UNITTO_PRDN_AREAINV_ITEM_IDSF_TOPA_IT_VW(SQL View) |
Index Back |
|---|---|
To Area/Item MA ID Vw02/01/99 SCC CN#SF800-9.0: Item prompt for to_prdn_area |
| 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 | TO_PRDN_AREA |
Character(10) | VARCHAR2(10) NOT NULL | To Production Area |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |