DBA Data[Home] [Help]

APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_CATEGORIES_B

Line 2443: FROM ams_categories_b cat

2439: AND tpl.enabled_flag = 'Y'
2440: AND det.enabled_flag = 'Y'
2441: AND ((1 = p_track_flag) OR
2442: (EXISTS (SELECT 1
2443: FROM ams_categories_b cat
2444: WHERE cat.category_id = met.metric_category
2445: AND ((1 = p_cost_flag AND category_id IN (901, 902)) OR
2446: (1 = p_amet_flag AND category_id NOT IN (901, 902))
2447: AND enabled_flag = 'Y'))))