DP_CONFIGVIEWDP_FORECASTITEMDP_INTFA_FI_VW(SQL View) |
Index Back |
|---|---|
Amend Stage, DP_FORECASTITEMPrompt Table for DP_FORECASTITEM, Forecast Adjustments. |
| SELECT DISTINCT A.DP_CONFIGVIEW , A.DP_FORECASTITEM , B.DP_FCITEMCAPTION FROM PS_DP_INT_ADJDATA A , PS_DP_FCITEMS B WHERE B.DP_CONFIGVIEW = A.DP_CONFIGVIEW AND B.DP_FORECASTITEM = A.DP_FORECASTITEM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW |
| 2 | DP_FORECASTITEM |
Character(120) | VARCHAR2(120) NOT NULL | DP_FORECASTITEM |
| 3 | DP_FCITEMCAPTION | Character(40) | VARCHAR2(40) NOT NULL | DP_FCITEMCAPTION |