SF_PA_PRDN_VW3(SQL View) |
Index Back |
---|---|
Prdn Area in Headr w/o ID's |
select distinct business_unit, prdn_area_code from PS_SF_PRDNID_HEADR where ma_prdn_id_flg = 'N' |
# | 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 |