eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AR_DISTRIBUTION_SETS_H_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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