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.BIM_SGMT_ACT_H_MV

Source


SELECT
			parent_segment_id	segment_id
			,src.activity_id		Activity_id
			,src.category_id		category_id
			,acts.source_code_id		source_code_id
			,src.start_date	schedule_start_date
			,src.child_object_purpose	schedule_purpose
			,COUNT(*) COUNT_ALL
		FROM  BIM.bim_i_sgmt_act_facts acts, BIM.bim_i_sgmt_denorm sgmt_denorm , BIM.bim_i_source_codes src
		WHERE acts.segment_id = sgmt_denorm.segment_id
		AND   acts.source_code_id = src.source_code_id
		GROUP BY parent_segment_id,src.activity_id, src.category_id,acts.source_code_id,src.start_date,src.child_object_purpose