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.

MATERIALIZED VIEW: APPS.FII_AR_DIMENSIONS_MV

Source


SELECT
         'ASSIGNED'  UMARKER,
  	 coll.party_id,
	 coll.cust_account_id,
	 coll.site_use_id,
	 coll.collector_id,
	 mkt.class_category,
	 mkt.class_code,
	 count(*) dummy_cnt_for_fast_refresh
  FROM
  	 FII.FII_COLLECTORS coll,
	 FII.FII_PARTY_MKT_CLASS mkt
  WHERE
         coll.party_id = mkt.party_id
  GROUP BY
         coll.party_id,
	 coll.cust_account_id,
	 coll.site_use_id,
	 coll.collector_id,
	 mkt.class_category,
	 mkt.class_code
  UNION ALL
  SELECT
         'UNASSIGNED'  UMARKER,
         -2              party_id,
	 -2              cust_account_id,
	 -2              site_use_id,
	 -1              collector_id,
	 class_category,
	 '-1'          class_code,
	 count(*)        dummy_cnt_for_fast_refresh
  FROM   FII.FII_AR_SETUP
  GROUP BY
	 class_category  -- avoid fast refreshable constraint