AR_DISTRIBUTION_SETS_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
DIST_SET_DESCRIPTION DIST_SET_ID DIST_SET_NAME DIST_SET_PERCENT_ALLOCATED EVENT_ID

Query

SQL_Statement
SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ dsa.description dist_set_description ,dsa.distribution_set_id dist_set_id ,dsa.distribution_set_name dist_set_name ,dsa.total_percent_distribution dist_set_percent_allocated ,he.event_id event_id FROM ar_distribution_sets_all dsa ,ar_xla_lines_extract he WHERE he.level_flag = 'H' AND dsa.distribution_set_id = he.distribution_set_id