[Home] [Help]
View: PSB_SERVICE_PACKAGES_V
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT SP.ROWID
, SP.SERVICE_PACKAGE_ID
, SP.NAME
, SP.SHORT_NAME
, SP.PRIORITY
, SP.DESCRIPTION
, SP.GLOBAL_WORKSHEET_ID
, WS.NAME
, SP.BASE_SERVICE_PACKAGE
, SP.ATTRIBUTE1
, SP.ATTRIBUTE2
, SP.ATTRIBUTE3
, SP.ATTRIBUTE4
, SP.ATTRIBUTE5
, SP.ATTRIBUTE6
, SP.ATTRIBUTE7
, SP.ATTRIBUTE8
, SP.ATTRIBUTE9
, SP.ATTRIBUTE10
, SP.CONTEXT
, SP.LAST_UPDATE_DATE
, SP.LAST_UPDATED_BY
, SP.LAST_UPDATE_LOGIN
, SP.CREATED_BY
, SP.CREATION_DATE
FROM PSB_SERVICE_PACKAGES SP
, PSB_WORKSHEETS WS
WHERE SP.GLOBAL_WORKSHEET_ID = WS.WORKSHEET_ID
Columns
| Name |
| ROW_ID |
| SERVICE_PACKAGE_ID |
| SERVICE_PACKAGE_NAME |
| SERVICE_PACKAGE_SHORT_NAME |
| PRIORITY |
| DESCRIPTION |
| GLOBAL_WORKSHEET_ID |
| GLOBAL_WORKSHEET_NAME |
| BASE_SERVICE_PACKAGE |
| ATTRIBUTE1 |
| ATTRIBUTE2 |
| ATTRIBUTE3 |
| ATTRIBUTE4 |
| ATTRIBUTE5 |
| ATTRIBUTE6 |
| ATTRIBUTE7 |
| ATTRIBUTE8 |
| ATTRIBUTE9 |
| ATTRIBUTE10 |
| CONTEXT |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| CREATED_BY |
| CREATION_DATE |