Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT VALS.ROWID
, VALS.VALUE_SEQUENCE_ID
, VALS.LINE_SEQUENCE_ID
, VALS.ATTRIBUTE_VALUE_ID
, VALS.ATTRIBUTE_VALUE
, VALS.LAST_UPDATE_DATE
, VALS.LAST_UPDATED_BY
, VALS.LAST_UPDATE_LOGIN
, VALS.CREATED_BY
, VALS.CREATION_DATE
, LINES.ATTRIBUTE_ID
, ATTRIBUTES.NAME
, ATTRIBUTES.VALUE_TABLE_FLAG
, ATTRIBUTE_VALUES.ATTRIBUTE_VALUE
FROM PSB_POSITION_SET_LINE_VALUES VALS
, PSB_ACCOUNT_POSITION_SET_LINES LINES
, PSB_ATTRIBUTES ATTRIBUTES
, PSB_ATTRIBUTE_VALUES ATTRIBUTE_VALUES
WHERE VALS.LINE_SEQUENCE_ID = LINES.LINE_SEQUENCE_ID(+)
AND LINES.ATTRIBUTE_ID = ATTRIBUTES.ATTRIBUTE_ID(+)
AND VALS.ATTRIBUTE_VALUE_ID = ATTRIBUTE_VALUES.ATTRIBUTE_VALUE_ID(+)