RS_FR_SUP_NAPRV(SQL View) |
Index Back |
|---|---|
Not Approved Supply ForecastsSCP - View to list all Supply forecasts that are in status-Pending |
| SELECT FORECAST_ID_SUP , DESCR , FROM_MONTH_SCP ,FROM_YEAR ,TO_MONTH_SCP ,TO_YEAR FROM %Table(RS_FR_SUP_HDR) WHERE SCENARIO_STATUS = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FORECAST_ID_SUP |
Character(15) | VARCHAR2(15) NOT NULL | Supply Forecast ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | FROM_MONTH_SCP | Character(2) | VARCHAR2(2) NOT NULL |
SCP- From Month
1=01 - January 10=10 - October 11=11 - November 12=12 - December 2=02 - February 3=03 - March 4=04 - April 5=05 - May 6=06 - June 7=07 - July 8=08 - August 9=09 - September |
| 4 | FROM_YEAR | Number(4,0) | SMALLINT NOT NULL | From Year |
| 5 | TO_MONTH_SCP | Character(2) | VARCHAR2(2) NOT NULL |
SCP- To Month
1=01 - January 10=10 - October 11=11 - November 12=12 - December 2=02 - February 3=03 - March 4=04 - April 5=05 - May 6=06 - June 7=07 - July 8=08 - August 9=09 - September |
| 6 | TO_YEAR | Number(4,0) | SMALLINT NOT NULL | To Year |