BUSINESS_UNITPRDN_AREA_CODESF_SCH_PA_VW(SQL View) |
Index Back |
|---|---|
Firmed and Released Schd AreasView of schedule prdn areas with status = Firmed or Released |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PRDN_AREA_CODE FROM PS_SF_PRDNID_HEADR A WHERE A.MA_PRDN_ID_FLG = 'N' AND A.PROD_STATUS IN ('15', '20') |
| # | 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 |