[Home] [Help]
View: PSBFV_POSITION_SET_LINES
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ST.NAME
, AT.NAME
, DECODE(VLN.ATTRIBUTE_VALUE_ID
, NULL
, VLN.ATTRIBUTE_VALUE
, VAT.ATTRIBUTE_VALUE)
, LN.LINE_SEQUENCE_ID
, LN.ACCOUNT_POSITION_SET_ID
, LN.ATTRIBUTE_ID
, LN.LAST_UPDATE_DATE
, LN.LAST_UPDATED_BY
, LN.CREATED_BY
, LN.CREATION_DATE
FROM PSB_ACCOUNT_POSITION_SETS ST
, PSB_ACCOUNT_POSITION_SET_LINES LN
, PSB_POSITION_SET_LINE_VALUES VLN
, PSB_ATTRIBUTES AT
, PSB_ATTRIBUTE_VALUES VAT
WHERE VLN.LINE_SEQUENCE_ID = LN.LINE_SEQUENCE_ID
AND VLN.ATTRIBUTE_VALUE_ID = VAT.ATTRIBUTE_VALUE_ID(+)
AND ST.ACCOUNT_POSITION_SET_ID = LN.ACCOUNT_POSITION_SET_ID
AND AT.ATTRIBUTE_ID(+) = LN.ATTRIBUTE_ID WITH READ ONLY
Columns
Name |
POSITION_SET_NAME |
ATTRIBUTE_NAME |
ATTRIBUTE_VALUE |
LINE_SEQUENCE_ID |
POSITION_SET_ID |
ATTRIBUTE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |