[Home] [Help]
View: PSBFV_POSITION_SET_LISTS
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | 10sc only |
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 |