BUSINESS_UNITPRDN_AREA_CODESF_PRID_H_VWB4(SQL View) |
Index Back |
|---|---|
Prdn Area in Headr Firm w/o ID2/17/99 RAG: CN# PL800-10.0 FPO |
| select distinct business_unit, prdn_area_code from PS_SF_PRDNID_HEADR where ma_prdn_id_flg = 'N' and prod_status in ( '10' , '15') |
| # | 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 |