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.

APPS.AMS_ACTMETRICS_SEED_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 934: ams_campaign_schedules_b c

930: UNION ALL
931: select distinct related_event_id, act_metric_used_by_id object_id,
932: arc_act_metric_used_by object_type
933: from ams_act_metrics_all a, ams_metrics_all_b b,
934: ams_campaign_schedules_b c
935: where a.metric_id = b.metric_id
936: AND b.metric_id in (127,137,147)
937: AND b.enabled_flag = G_IS_ENABLED
938: AND NVL(A.last_calculated_date,l_today) > l_today - G_CALC_LAG_DAYS

Line 1479: from ams_act_metrics_all a, ams_metrics_all_b b, ams_campaign_schedules_b c

1475: from ams_event_registrations r,
1476: (select distinct related_event_id event_offer_id,
1477: act_metric_used_by_id object_id,
1478: arc_act_metric_used_by object_type
1479: from ams_act_metrics_all a, ams_metrics_all_b b, ams_campaign_schedules_b c
1480: where a.metric_id = b.metric_id
1481: AND b.metric_id in (127,137,147)
1482: AND a.ARC_ACT_METRIC_USED_BY = G_CSCH
1483: AND b.enabled_flag = G_IS_ENABLED

Line 2455: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,

2451: 'B2B', ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID, null)
2452: CONTACT_REL_PARTY_ID,
2453: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID,
2454: SRC.SOURCE_CATEGORY, CS.SCHEDULE_ID OBJECT_ID
2455: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,
2456: AMS_LIST_HEADERS_ALL LHA ,
2457: AMS_LIST_ENTRIES ENTRY ,
2458: AMS_ACT_METRICS_ALL AM ,
2459: AMS_METRICS_ALL_B MB,

Line 2562: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,

2558: 'B2B', ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID, null)
2559: CONTACT_REL_PARTY_ID,
2560: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID,
2561: SRC.SOURCE_CATEGORY, CS.SCHEDULE_ID OBJECT_ID
2562: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,
2563: AMS_LIST_HEADERS_ALL LHA ,
2564: AMS_LIST_ENTRIES ENTRY ,
2565: AMS_ACT_METRICS_ALL AM ,
2566: AMS_METRICS_ALL_B MB,

Line 2665: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,

2661: 'B2B', ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID, null)
2662: CONTACT_REL_PARTY_ID,
2663: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID,
2664: SRC.SOURCE_CATEGORY, CS.SCHEDULE_ID OBJECT_ID
2665: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,
2666: AMS_LIST_HEADERS_ALL LHA ,
2667: AMS_LIST_ENTRIES ENTRY ,
2668: AMS_ACT_METRICS_ALL AM ,
2669: AMS_METRICS_ALL_B MB,

Line 2780: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,

2776: 'B2B', ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID, null)
2777: CONTACT_REL_PARTY_ID,
2778: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID,
2779: SRC.SOURCE_CATEGORY, CS.SCHEDULE_ID OBJECT_ID
2780: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,
2781: AMS_LIST_HEADERS_ALL LHA ,
2782: AMS_LIST_ENTRIES ENTRY ,
2783: AMS_ACT_METRICS_ALL AM ,
2784: AMS_METRICS_ALL_B MB,

Line 2907: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,

2903: 'B2B', ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID, null)
2904: CONTACT_REL_PARTY_ID,
2905: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID,
2906: SRC.SOURCE_CATEGORY, CS.SCHEDULE_ID OBJECT_ID
2907: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,
2908: AMS_LIST_HEADERS_ALL LHA ,
2909: AMS_LIST_ENTRIES ENTRY ,
2910: AMS_ACT_METRICS_ALL AM ,
2911: AMS_METRICS_ALL_B MB,

Line 3054: AMS_CAMPAIGN_SCHEDULES_B CS ,

3050: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID,
3051: SRC.SOURCE_CATEGORY, CS.SCHEDULE_ID OBJECT_ID
3052: FROM AMS_METRICS_ALL_B MB,
3053: AMS_ACT_METRICS_ALL AM ,
3054: AMS_CAMPAIGN_SCHEDULES_B CS ,
3055: AMS_LIST_HEADERS_ALL LHA ,
3056: AMS_LIST_ENTRIES ENTRY ,
3057: HZ_RELATIONSHIPS REL,
3058: AMS_LIST_SRC_TYPES SRC

Line 3215: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,

3211: 'B2B', ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID, null)
3212: CONTACT_REL_PARTY_ID,
3213: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID,
3214: SRC.SOURCE_CATEGORY
3215: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,
3216: AMS_LIST_HEADERS_ALL LHA , AMS_LIST_ENTRIES ENTRY ,
3217: AMS_ACT_METRICS_ALL AM , AMS_METRICS_ALL_B MB, HZ_RELATIONSHIPS REL,
3218: AMS_LIST_SRC_TYPES SRC
3219: WHERE AM.METRIC_ID = MB.METRIC_ID

Line 3326: AMS_CAMPAIGN_SCHEDULES_B CS ,

3322: 'B2B', ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID, null) CONTACT_REL_PARTY_ID,
3323: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID, SRC.SOURCE_CATEGORY, CS.SCHEDULE_ID OBJECT_ID
3324: FROM AMS_METRICS_ALL_B MB,
3325: AMS_ACT_METRICS_ALL AM ,
3326: AMS_CAMPAIGN_SCHEDULES_B CS ,
3327: AMS_LIST_HEADERS_ALL LHA ,
3328: AMS_LIST_ENTRIES ENTRY ,
3329: HZ_RELATIONSHIPS REL,
3330: AMS_LIST_SRC_TYPES SRC

Line 3362: AMS_CAMPAIGN_SCHEDULES_B CS ,

3358: ''B2B'', ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID, null) CONTACT_REL_PARTY_ID,
3359: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID, SRC.SOURCE_CATEGORY, CS.SCHEDULE_ID OBJECT_ID
3360: FROM AMS_METRICS_ALL_B MB,
3361: AMS_ACT_METRICS_ALL AM ,
3362: AMS_CAMPAIGN_SCHEDULES_B CS ,
3363: AMS_LIST_HEADERS_ALL LHA ,
3364: AMS_LIST_ENTRIES ENTRY ,
3365: HZ_RELATIONSHIPS REL,
3366: AMS_LIST_SRC_TYPES SRC

Line 3511: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,

3507: 'B2B', ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID, null)
3508: CONTACT_REL_PARTY_ID,
3509: CS.LAST_ACTIVATION_DATE, AM.ACTIVITY_METRIC_ID,
3510: SRC.SOURCE_CATEGORY, CS.SCHEDULE_ID OBJECT_ID
3511: FROM AMS_CAMPAIGN_SCHEDULES_B CS ,
3512: AMS_LIST_HEADERS_ALL LHA ,
3513: AMS_LIST_ENTRIES ENTRY ,
3514: AMS_ACT_METRICS_ALL AM ,
3515: AMS_METRICS_ALL_B MB,