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 HZ_RELATIONSHIPS

Line 2015: HZ_RELATIONSHIPS REL,

2011: FROM AMS_ACT_LISTS ACTLIST,
2012: AMS_LIST_ENTRIES ENTRY,
2013: AMS_SOURCE_CODES SOURCE,
2014: AMS_LIST_SRC_TYPES SRC,
2015: HZ_RELATIONSHIPS REL,
2016: AMS_METRICS_ALL_B B,
2017: AMS_ACT_METRICS_ALL A
2018: WHERE ENTRY.LIST_HEADER_ID = ACTLIST.LIST_HEADER_ID
2019: AND SOURCE.SOURCE_CODE_FOR_ID = ACTLIST.LIST_USED_BY_ID

Line 2095: HZ_RELATIONSHIPS REL,

2091: FROM AMS_ACT_LISTS ACTLIST,
2092: AMS_LIST_ENTRIES ENTRY,
2093: AMS_SOURCE_CODES SOURCE,
2094: AMS_LIST_SRC_TYPES SRC,
2095: HZ_RELATIONSHIPS REL,
2096: AMS_METRICS_ALL_B B,
2097: AMS_ACT_METRICS_ALL A
2098: WHERE ENTRY.LIST_HEADER_ID = ACTLIST.LIST_HEADER_ID
2099: AND SOURCE.SOURCE_CODE_FOR_ID = ACTLIST.LIST_USED_BY_ID

Line 2168: HZ_RELATIONSHIPS REL,

2164: FROM AMS_ACT_LISTS ACTLIST,
2165: AMS_LIST_ENTRIES ENTRY,
2166: AMS_SOURCE_CODES SOURCE,
2167: AMS_LIST_SRC_TYPES SRC,
2168: HZ_RELATIONSHIPS REL,
2169: AMS_METRICS_ALL_B B,
2170: AMS_ACT_METRICS_ALL A
2171: WHERE ENTRY.LIST_HEADER_ID = ACTLIST.LIST_HEADER_ID
2172: AND SOURCE.SOURCE_CODE_FOR_ID = ACTLIST.LIST_USED_BY_ID

Line 2299: HZ_RELATIONSHIPS REL,

2295: actlist_SOURCE.SOURCE_CODE_ID, src.source_category,
2296: actlist_source.object_type, actlist_source.object_id
2297: FROM AMS_LIST_ENTRIES ENTRY,
2298: AMS_LIST_SRC_TYPES SRC,
2299: HZ_RELATIONSHIPS REL,
2300: (select distinct source_code_for_id, arc_source_code_for,
2301: source_code_id, 'ALIST' object_type,
2302: ACTLIST.ACT_LIST_HEADER_ID object_id,
2303: ACTLIST.LIST_HEADER_ID

Line 2460: HZ_RELATIONSHIPS REL,

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,
2461: AMS_LIST_SRC_TYPES SRC
2462: WHERE AM.METRIC_ID = MB.METRIC_ID
2463: AND AM.ARC_ACT_METRIC_USED_BY = 'CSCH'
2464: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID

Line 2567: HZ_RELATIONSHIPS REL,

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,
2568: AMS_LIST_SRC_TYPES SRC
2569: WHERE AM.METRIC_ID = MB.METRIC_ID
2570: AND AM.ARC_ACT_METRIC_USED_BY = 'CSCH'
2571: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID

Line 2670: HZ_RELATIONSHIPS REL,

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,
2671: AMS_LIST_SRC_TYPES SRC
2672: WHERE AM.METRIC_ID = MB.METRIC_ID
2673: AND AM.ARC_ACT_METRIC_USED_BY = 'CSCH'
2674: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID

Line 2785: HZ_RELATIONSHIPS REL,

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,
2786: AMS_LIST_SRC_TYPES SRC
2787: WHERE AM.METRIC_ID = MB.METRIC_ID
2788: AND AM.ARC_ACT_METRIC_USED_BY = 'CSCH'
2789: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID

Line 2912: HZ_RELATIONSHIPS REL,

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,
2913: AMS_LIST_SRC_TYPES SRC
2914: WHERE AM.METRIC_ID = MB.METRIC_ID
2915: AND AM.ARC_ACT_METRIC_USED_BY = 'CSCH'
2916: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID

Line 3057: HZ_RELATIONSHIPS REL,

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
3060: AND AM.ARC_ACT_METRIC_USED_BY = 'CSCH'
3061: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID

Line 3217: AMS_ACT_METRICS_ALL AM , AMS_METRICS_ALL_B MB, HZ_RELATIONSHIPS REL,

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'
3221: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID

Line 3329: HZ_RELATIONSHIPS REL,

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
3332: AND AM.ARC_ACT_METRIC_USED_BY = 'CSCH'
3333: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID

Line 3365: HZ_RELATIONSHIPS REL,

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
3368: AND AM.ARC_ACT_METRIC_USED_BY = ''CSCH''
3369: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID

Line 3516: HZ_RELATIONSHIPS REL,

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,
3517: AMS_LIST_SRC_TYPES SRC
3518: WHERE AM.METRIC_ID = MB.METRIC_ID
3519: AND AM.ARC_ACT_METRIC_USED_BY = 'CSCH'
3520: AND AM.ACT_METRIC_USED_BY_ID = CS.SCHEDULE_ID