VIEW: APPS.PSBFV_POSITION_SET_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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