ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4253869E053B46B63588994Y 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 PSB PSBRPPOS_XML US PSB Position Set Listing Application: Public Sector Budgeting (Obsolete) Source: Position Set Listing (XML) Short Name: PSBRPPOS_XML DB package: PSB_PSBRPPOS_XMLP_PKG BI Publisher :extract_id :p_account_position_set_id :p_data_extract_id 1 10 :p_data_extract_id LOV Oracle PSB_DATA_EXTRACTS Y select data_extract_id id, data_extract_name value, null description from psb_data_extracts order by data_extract_name US Data Extract Name 2 20 :p_account_position_set_id LOV Oracle PSB_SRS_POSITION_SET Y select account_position_set_id id, name value, null description from psb_account_position_sets where account_or_position_type='P' order by name US Position Set Name