DP_REFRESH_VW(SQL View) |
Index Back |
---|---|
Fcst Items Refresh Spec ViewSELECT A.DP_CONFIGVIEW ,B.DP_SPECS_ID , B.DESCR60 FROM PS_DP_VIEW4USER_VW A , PS_DP_REFRESH_HDR B WHERE A.OPRID = %OperatorId AND B.DP_CONFIGVIEW = A.DP_CONFIGVIEW |
SELECT DP_CONFIGVIEW ,DP_SPECS_ID , DESCR60 FROM PS_DP_REFRESH_HDR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DP_CONFIGVIEW | Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW |
2 | DP_SPECS_ID | Character(20) | VARCHAR2(20) NOT NULL | DP_SPECS_ID |
3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |