DESCRKK_XCP_BDDSC_VW(SQL View) |
Index Back |
|---|---|
Budget Description PromptPrompt view of DESCR in Budget Exception Search View |
| SELECT DISTINCT B.DESCR FROM PS_KK_EXCPTN_TBL A ,PS_KK_BUDGET_TYPE B WHERE B.LEDGER_GROUP = A.LEDGER_GROUP AND B.SETID1 = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'KK_BD_TYPE_VW') AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_KK_BUDGET_TYPE B1 WHERE B1.LEDGER_GROUP = B.LEDGER_GROUP AND B1.SETID1 = B.SETID1 AND B1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |