SETIDPRDN_AREA_CODETML_PRDN_AR_VW(SQL View) |
Index Back |
|---|---|
Rpl Location Storage Area VWRpl Location Storage Area VW for Item Template |
| SELECT DISTINCT sc.setid , c.prdn_area_code , c.prdn_area_desc FROM ps_set_cntrl_rec sc , ps_bus_unit_tbl_mg a , PS_BUS_UNIT_TBL_FS b , ps_sf_prdn_area c , ps_sf_prdn_area_it d WHERE sc.recname = 'MASTER_ITEM_TBL' AND a.business_unit = sc.setcntrlvalue AND a.business_unit = b.business_unit AND a.bu_status = '1' AND a.business_unit = c.business_unit AND d.ma_prdn_id_flg = 'N' AND d.business_unit = c.business_unit |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 3 | PRDN_AREA_DESC | Character(30) | VARCHAR2(30) NOT NULL | Description |