VIEW: APPS.PSB_POSITION_SET_LINE_VALUES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)