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_LIST_HEADERS_ALL

Line 1692: FROM ams_list_headers_all ALH, ams_act_metrics_all al,

1688: AL.activity_metric_id,AL.func_actual_value
1689: FROM
1690: (SELECT al.activity_metric_id,
1691: alh.no_of_rows_active, alh.no_of_rows_in_ctrl_group
1692: FROM ams_list_headers_all ALH, ams_act_metrics_all al,
1693: ams_metrics_all_b alb
1694: WHERE ALH.arc_list_used_by = al.arc_act_metric_used_by
1695: AND ALH.list_used_by_id = al.act_metric_used_by_id
1696: AND al.metric_id = alb.metric_id

Line 1751: FROM ams_list_headers_all ALH, ams_act_metrics_all al,

1747: AL.activity_metric_id,AL.func_actual_value
1748: FROM
1749: (SELECT al.activity_metric_id,
1750: alh.no_of_rows_active, alh.no_of_rows_in_ctrl_group
1751: FROM ams_list_headers_all ALH, ams_act_metrics_all al,
1752: ams_metrics_all_b alb
1753: WHERE ALH.arc_list_used_by = al.arc_act_metric_used_by
1754: AND ALH.list_used_by_id = al.act_metric_used_by_id
1755: AND al.metric_id = alb.metric_id

Line 2456: AMS_LIST_HEADERS_ALL LHA ,

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,
2460: HZ_RELATIONSHIPS REL,

Line 2563: AMS_LIST_HEADERS_ALL LHA ,

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,
2567: HZ_RELATIONSHIPS REL,

Line 2666: AMS_LIST_HEADERS_ALL LHA ,

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,
2670: HZ_RELATIONSHIPS REL,

Line 2781: AMS_LIST_HEADERS_ALL LHA ,

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,
2785: HZ_RELATIONSHIPS REL,

Line 2908: AMS_LIST_HEADERS_ALL LHA ,

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,
2912: HZ_RELATIONSHIPS REL,

Line 3055: AMS_LIST_HEADERS_ALL LHA ,

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
3059: WHERE AM.METRIC_ID = MB.METRIC_ID

Line 3216: AMS_LIST_HEADERS_ALL LHA , AMS_LIST_ENTRIES ENTRY ,

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
3220: AND AM.ARC_ACT_METRIC_USED_BY = 'CSCH'

Line 3327: AMS_LIST_HEADERS_ALL LHA ,

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
3331: WHERE AM.METRIC_ID = MB.METRIC_ID

Line 3363: AMS_LIST_HEADERS_ALL LHA ,

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
3367: WHERE AM.METRIC_ID = MB.METRIC_ID

Line 3512: AMS_LIST_HEADERS_ALL LHA ,

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,
3516: HZ_RELATIONSHIPS REL,