APPS.AMS_ACTMETRICS_SEED_PVT dependencies on AMS_ACT_LISTS

Line 1842: FROM ams_act_lists actlist

1838: FROM
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

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 1890: FROM ams_act_lists actlist

1886: FROM
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

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 2011: FROM AMS_ACT_LISTS ACTLIST,

2007: decode(src.source_category,
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,

Line 2091: FROM AMS_ACT_LISTS ACTLIST,

2087: decode(src.source_category,
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,

Line 2164: FROM AMS_ACT_LISTS ACTLIST,

2160: decode(src.source_category,
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,

Line 2304: from ams_source_codes source, AMS_ACT_LISTS ACTLIST,

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
2304: from ams_source_codes source, AMS_ACT_LISTS ACTLIST,
2305: ams_metrics_all_b b, ams_act_metrics_all a
2306: where a.metric_id = b.metric_id
2307: AND b.metric_id in (336,341,346)
2308: AND b.enabled_flag = G_IS_ENABLED