DBA Data[Home] [Help]

APPS.AMS_ACTMETRICS_ENGINE_PVT dependencies on AMS_LOOKUPS

Line 632: (select lookup_code from ams_lookups

628: compute_using_function ,
629: default_uom_code, display_type
630: FROM ams_act_metrics_all a, ams_metrics_all_b b
631: WHERE arc_act_metric_used_by IN
632: (select lookup_code from ams_lookups
633: where lookup_type in ('AMS_METRIC_OBJECT_TYPE', 'AMS_METRIC_ROLLUP_TYPE'))
634: -- Replaced with metadata lookups above.
635: --(G_CAMP, G_CSCH, G_DELV, G_EVEO, G_EVEH, G_RCAM, G_EONE)
636: --BUG2845365: Removed dialogue components.

Line 2983: ams_lookups lkup

2979: metric_category,
2980: TRANSACTION_CURRENCY_CODE,
2981: functional_currency_code
2982: FROM ams_metrics_all_b a, ams_act_metrics_all b,
2983: ams_lookups lkup
2984: WHERE a.metric_id = b.metric_id
2985: -- BUG4924982: Performance, join to metric definition.
2986: AND a.arc_metric_used_for_object = lkup.lookup_code
2987: AND lookup_type = 'AMS_METRIC_OBJECT_TYPE'

Line 3011: (select lookup_code from ams_lookups

3007: CURSOR c_met_procedures IS
3008: SELECT DISTINCT function_name
3009: FROM ams_metrics_all_b
3010: WHERE arc_metric_used_for_object IN
3011: (select lookup_code from ams_lookups
3012: where lookup_type = 'AMS_METRIC_OBJECT_TYPE')
3013: -- Replaced with metadata lookups above.
3014: --(G_CAMP, G_CSCH, G_DELV, G_EVEO, G_EVEH, G_RCAM, G_EONE)
3015: --BUG2845365: Removed dialogue components.