PSB Position Set Listing

Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Position Set Listing (XML)
Short Name: PSBRPPOS_XML
DB package: PSB_PSBRPPOS_XMLP_PKG
SELECT  DISTINCT pps.name setname,
              decode(pps.attribute_selection_type,'A','All','O','Atleast One') selection,
              psl.attribute_name attr_name,
              decode(psv.attribute_value_table_flag,'Y',psv.attribute_table_value,psv.attribute_value) attr_val,
              pps.data_extract_id
FROM     psb_account_position_sets pps, psb_acct_position_set_lines_v psl,
              psb_position_set_line_values_v psv
WHERE   pps.data_extract_id = :extract_id
AND        pps.account_position_set_id = psl.account_position_set_id
AND        psl.line_sequence_id = psv.line_sequence_id
AND        psl.attribute_id = psv.attribute_id
AND       (
             ((:p_account_position_set_id IS NULL OR pps.account_position_set_id =                
	:p_account_position_set_id) 
              AND (:p_data_extract_id IS NULL OR pps.data_extract_id = :p_data_extract_id))
            ) 
 and pps.data_extract_id=:extract_id
ORDER BY 1,3,4
Parameter Name SQL text Validation
Position Set Name
 
LOV Oracle
Data Extract Name
 
LOV Oracle