[Home] [Help]
View: PSBBV_POSITION_SET_LISTS
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT ST.NAME
, DT.DATA_EXTRACT_NAME
, PS.NAME
, PO.ACCOUNT_POSITION_SET_ID
, PO.DATA_EXTRACT_ID
, PO.POSITION_ID
, PO.LAST_UPDATE_DATE
, PO.LAST_UPDATED_BY
, PO.CREATED_BY
, PO.CREATION_DATE
FROM PSB_BUDGET_POSITIONS PO
, PSB_POSITIONS PS
, PSB_DATA_EXTRACTS DT
, PSB_ACCOUNT_POSITION_SETS ST
WHERE PO.POSITION_ID = PS.POSITION_ID
AND DT.DATA_EXTRACT_ID = PS.DATA_EXTRACT_ID
AND ST.ACCOUNT_POSITION_SET_ID = PO.ACCOUNT_POSITION_SET_ID WITH READ ONLY
Columns
| Name |
| POSITION_SET_NAME |
| DATA_EXTRACT_NAME |
| POSITION_NAME |
| POSITION_SET_ID |
| DATA_EXTRACT_ID |
| POSITION_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATED_BY |
| CREATION_DATE |