BUSINESS_UNITMFG_YEARMG_CALENDAR_VW2(SQL View) |
Index Back |
|---|---|
Production Calendar View12/04/97 RPS (CN# MG700-1.0): Print Calendar Report |
| select a.business_unit, a.mfg_year from PS_MG_CALENDAR a, ps_bus_unit_opt_mg b where a.business_unit=b.business_unit and a.calendar_code=b.calendar_code_pr group by a.business_unit, a.mfg_year |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | MFG_YEAR |
Number(4,0) | SMALLINT NOT NULL | Year |