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_ENTRIES

Line 1843: , ams_list_entries LIST

1839: (
1840: SELECT LIST.list_entry_id, 'ALIST' object_type,
1841: actlist.act_list_header_id
1842: FROM ams_act_lists actlist
1843: , ams_list_entries LIST
1844: , ams_act_metrics_all a
1845: , ams_metrics_all_b b
1846: WHERE LIST.list_header_id = actlist.list_header_id
1847: AND actlist.list_act_type = 'LIST'

Line 1849: FROM ams_list_entries target, ams_act_lists acttarget

1845: , ams_metrics_all_b b
1846: WHERE LIST.list_header_id = actlist.list_header_id
1847: AND actlist.list_act_type = 'LIST'
1848: AND EXISTS (SELECT 1
1849: FROM ams_list_entries target, ams_act_lists acttarget
1850: WHERE acttarget.list_used_by = actlist.list_used_by
1851: AND acttarget.list_used_by_id = actlist.list_used_by_id
1852: AND acttarget.list_act_type = 'TARGET'
1853: AND target.list_header_id = acttarget.list_header_id

Line 1891: , ams_list_entries LIST

1887: (
1888: SELECT LIST.list_entry_id, 'ALIST' object_type,
1889: actlist.act_list_header_id
1890: FROM ams_act_lists actlist
1891: , ams_list_entries LIST
1892: , ams_act_metrics_all a
1893: , ams_metrics_all_b b
1894: WHERE LIST.list_header_id = actlist.list_header_id
1895: AND actlist.list_act_type = 'LIST'

Line 1897: FROM ams_list_entries target, ams_act_lists acttarget

1893: , ams_metrics_all_b b
1894: WHERE LIST.list_header_id = actlist.list_header_id
1895: AND actlist.list_act_type = 'LIST'
1896: AND EXISTS (SELECT 1
1897: FROM ams_list_entries target, ams_act_lists acttarget
1898: WHERE acttarget.list_used_by = actlist.list_used_by
1899: AND acttarget.list_used_by_id = actlist.list_used_by_id
1900: AND acttarget.list_act_type = 'TARGET'
1901: AND target.list_header_id = acttarget.list_header_id

Line 2012: AMS_LIST_ENTRIES ENTRY,

2008: 'B2C',ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID,
2009: 'B2B',REL.OBJECT_ID,null) PARTY_ID,
2010: SOURCE.SOURCE_CODE_ID, src.source_category
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,

Line 2092: AMS_LIST_ENTRIES ENTRY,

2088: 'B2C',ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID,
2089: 'B2B',REL.OBJECT_ID,null) PARTY_ID,
2090: SOURCE.SOURCE_CODE_ID, src.source_category
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,

Line 2165: AMS_LIST_ENTRIES ENTRY,

2161: 'B2C',ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID,
2162: 'B2B',REL.OBJECT_ID,null) PARTY_ID,
2163: SOURCE.SOURCE_CODE_ID, src.source_category
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,

Line 2297: FROM AMS_LIST_ENTRIES ENTRY,

2293: 'B2C',ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID,
2294: 'B2B',REL.OBJECT_ID,null) PARTY_ID,
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,

Line 2457: AMS_LIST_ENTRIES ENTRY ,

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,
2461: AMS_LIST_SRC_TYPES SRC

Line 2564: AMS_LIST_ENTRIES ENTRY ,

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,
2568: AMS_LIST_SRC_TYPES SRC

Line 2667: AMS_LIST_ENTRIES ENTRY ,

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,
2671: AMS_LIST_SRC_TYPES SRC

Line 2782: AMS_LIST_ENTRIES ENTRY ,

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,
2786: AMS_LIST_SRC_TYPES SRC

Line 2909: AMS_LIST_ENTRIES ENTRY ,

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,
2913: AMS_LIST_SRC_TYPES SRC

Line 3056: AMS_LIST_ENTRIES ENTRY ,

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

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 3328: AMS_LIST_ENTRIES ENTRY ,

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

Line 3364: AMS_LIST_ENTRIES ENTRY ,

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

Line 3513: AMS_LIST_ENTRIES ENTRY ,

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,
3517: AMS_LIST_SRC_TYPES SRC