BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_MG
PRDN_AREA_CODESF_PA_PID_VW11(SQL View) |
Index Back |
|---|---|
Prdn IDs: By PID, status 20-40 |
| Select distinct business_unit, prdn_area_code From PS_SF_PRDNID_HEADR Where ma_prdn_id_flg = 'Y' and (prod_status = '20' or prod_status = '30' or prod_status = '40') and (production_type = 'PR' or production_type = 'RW') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_MG |
| 2 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |