[Home] [Help]
View: PSBBV_POSITION_SET_LINES
View Text
SELECT 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_SET_LINES LN
, PSB_POSITION_SET_LINE_VALUES VLN
, PSB_ATTRIBUTE_VALUES VAT
, PSB_ATTRIBUTES AT
WHERE VLN.LINE_SEQUENCE_ID = LN.LINE_SEQUENCE_ID
AND AT.ATTRIBUTE_ID = LN.ATTRIBUTE_ID
AND VLN.ATTRIBUTE_VALUE_ID = VAT.ATTRIBUTE_VALUE_ID(+) WITH READ ONLY
Columns
| Name |
| ATTRIBUTE_NAME |
| ATTRIBUTE_VALUE |
| LINE_SEQUENCE_ID |
| POSITION_SET_ID |
| ATTRIBUTE_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATED_BY |
| CREATION_DATE |