BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_MG
PRDN_AREA_CODESF_PA_PID_VW12(SQL View) |
Index Back |
|---|---|
Prdn Areas by PID status 20-40 |
| SELECT DISTINCT business_unit , prdn_area_code FROM PS_SF_PRDNID_HEADR WHERE (prod_status = '20' OR prod_status = '30' OR prod_status = '40') AND (production_type = 'PR' OR production_type = 'RW' OR production_type = 'TD') |
| # | 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 |