ALIAS_NAMECSH_FCST_GRP_VW(SQL View) |
Index Back |
|---|---|
Cash Forecast Group By ViewCash Forecast Group By View |
| SELECT DISTINCT B.ALIAS_NAME , C.DESCR FROM PS_CSH_FCST_GROUP A , PS_CSH_FCST_GRP_BY B , PS_POS_FIELD_TYPE C WHERE A.CSH_FCST_MAP_ID = B.CSH_FCST_MAP_ID AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX (EFFDT) FROM PS_CSH_FCST_GROUP C WHERE C.CSH_FCST_MAP_ID = A.CSH_FCST_MAP_ID AND C.EFFDT <=%CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.ALIAS_NAME <> ' ' AND B.FIELDNAME_TO <> 'CURRENCY_CD' AND C.ALIAS_NAME = B.ALIAS_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ALIAS_NAME |
Character(30) | VARCHAR2(30) NOT NULL | "A user defined synonym |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |