PSB Position Set Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Position Set Listing (XML)
Short Name: PSBRPPOS_XML
DB package: PSB_PSBRPPOS_XMLP_PKG
Run PSB Position Set Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Data Extract Name 
 
 LOV Oracle
Position Set Name 
 
 LOV Oracle
Download
Related Blitz Reports
PSB Stage Variance Report for Position PSB Stage Variance Report for Position by Responsibility PSB Pooled Position Report for Worksheet PSB Pooled Position Report for Worksheet by Responsibility PSB Budget Group Account Ranges Listing PSB Vacant Position PSB Vacant Position Report by Responsibility PSB Worksheet Position Costing Report by Responsibility PSB Worksheet Position Costing Report XML
Blitz Report™

Blitz Report™ provides multiple benefits: