GLRN_STATUS_TGLRN_STAT_A_VW(SQL View) |
Index Back |
|---|---|
GLRN_STAT_A_VWAccount reconciliation approver action view |
| SELECT GLRN_RECON_STATUS , ACTION_DESCR FROM PS_GLRN_STATUS_TBL WHERE GLRN_RECON_STATUS IN ( SELECT DISTINCT B.GLRN_STATUS_T FROM PS_GLRN_STATUS_TBL A ,PS_GLRN_SEC_STAT B WHERE A.GLRN_STATUS_TYPE = 1 AND A.GLRN_RECON_STATUS = B.GLRN_STATUS_F AND B.GLRN_USER_FUNCTION ='A' AND B.ENABLED = 'Y' UNION SELECT DISTINCT B.GLRN_STATUS_T FROM PS_GLRN_STATUS_TBL A ,PS_GLRN_USR_STAT B WHERE A.GLRN_STATUS_TYPE = 1 AND A.GLRN_RECON_STATUS = B.GLRN_STATUS_F AND B.ENABLED = 'Y' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GLRN_STATUS_T |
Character(1) | VARCHAR2(1) NOT NULL | Reconciliation Status Number |
| 2 | ACTION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Status Action |