BUSINESS_UNITCONTROL_BUDGETKK_BD_DESCR_VW2(SQL View) |
Index Back |
|---|---|
Control Budget Descr by BU |
| SELECT DISTINCT A.BUSINESS_UNIT ,B.DESCR FROM PS_BU_LED_GRP_TBL A ,PS_KK_BUDGET_TYPE B ,PS_SET_CNTRL_REC C WHERE B.LEDGER_GROUP = A.LEDGER_GROUP AND B.SETID1=C.SETID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CONTROL_BUDGET |
Character(30) | VARCHAR2(30) NOT NULL | Budget Type |