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_DMSELECTION_PVT dependencies on AMS_DM_ORG_CONTACTS

Line 66: -- 06-Nov-2003 rosharma Renamed ams_dm_org_contacts_stg to ams_dm_org_contacts

62: -- 31-Oct-2003 kbasavar Changes to populate_targets to handle B2B Customer
63: -- Profitbility model for List data Source uptake
64: -- 02-Nov-2003 kbasavar Changed to use categories table instead of view
65: -- for performance
66: -- 06-Nov-2003 rosharma Renamed ams_dm_org_contacts_stg to ams_dm_org_contacts
67: -- 21-Nov-2003 choang bug 3275817 - changed to not exists and having clause
68: -- 27-Nov-2003 rosharma Fixed ambiguous column issue when cell or diwb is included in training data
69: -- 02-Dec-2003 rosharma Bug # 3290898
70: -- 09-Dec-2003 kbasavar Added is_org_prod_affn for Org Product Affinity Model

Line 898: -- l_insert_clause := 'INSERT INTO ams_dm_org_contacts_stg (arc_object_used_by, ';

894: IF p_seeded_data_source THEN
895:
896: IF l_is_b2b AND l_model_type='CUSTOMER_PROFITABILITY' THEN
897: -- nyostos - Sep 15, 2003 - Use Global Temporart Table
898: -- l_insert_clause := 'INSERT INTO ams_dm_org_contacts_stg (arc_object_used_by, ';
899: -- l_insert_clause := 'INSERT INTO ams_dm_orgcont_stg_gt (arc_object_used_by, ';
900: l_insert_clause := 'INSERT INTO ams_dm_org_contacts (arc_object_used_by, ';
901: l_insert_clause := l_insert_clause || 'object_used_by_id, arc_object, ';
902: l_insert_clause := l_insert_clause || 'object_id, party_id, org_party_id) SELECT ';

Line 900: l_insert_clause := 'INSERT INTO ams_dm_org_contacts (arc_object_used_by, ';

896: IF l_is_b2b AND l_model_type='CUSTOMER_PROFITABILITY' THEN
897: -- nyostos - Sep 15, 2003 - Use Global Temporart Table
898: -- l_insert_clause := 'INSERT INTO ams_dm_org_contacts_stg (arc_object_used_by, ';
899: -- l_insert_clause := 'INSERT INTO ams_dm_orgcont_stg_gt (arc_object_used_by, ';
900: l_insert_clause := 'INSERT INTO ams_dm_org_contacts (arc_object_used_by, ';
901: l_insert_clause := l_insert_clause || 'object_used_by_id, arc_object, ';
902: l_insert_clause := l_insert_clause || 'object_id, party_id, org_party_id) SELECT ';
903: l_is_b2b_custprof := TRUE;
904: END IF;

Line 1029: FROM ams_dm_org_contacts GROUP BY arc_object_used_by,object_used_by_id,arc_object,object_id,org_party_id';

1025: -- l_insert_string := l_insert_string || 'FROM ams_dm_orgcont_stg_gt ';
1026: -- l_insert_string := l_insert_string || 'GROUP BY arc_object_used_by,object_used_by_id,arc_object,object_id,org_party_id ';
1027: EXECUTE IMMEDIATE 'INSERT INTO ams_dm_target_stg_gt(arc_object_used_by,object_used_by_id,arc_object,object_id,party_id)
1028: SELECT arc_object_used_by,object_used_by_id,arc_object,object_id,org_party_id
1029: FROM ams_dm_org_contacts GROUP BY arc_object_used_by,object_used_by_id,arc_object,object_id,org_party_id';
1030: END IF;
1031:
1032: ELSE -- alternative data source
1033: IF p_arc_object_for = 'MODL' THEN

Line 1290: -- DELETE FROM ams_dm_org_contacts_stg WHERE ARC_OBJECT_USED_BY = p_arc_object_for AND OBJECT_USED_BY_ID = p_object_for_id;

1286:
1287:
1288:
1289: if l_model_type='CUSTOMER_PROFITABILITY' THEN
1290: -- DELETE FROM ams_dm_org_contacts_stg WHERE ARC_OBJECT_USED_BY = p_arc_object_for AND OBJECT_USED_BY_ID = p_object_for_id;
1291: -- DELETE FROM ams_dm_orgcont_stg_gt WHERE ARC_OBJECT_USED_BY = p_arc_object_for AND OBJECT_USED_BY_ID = p_object_for_id;
1292: if p_count = 'FINAL' and p_arc_object_for = G_OBJECT_TYPE_SCORE then
1293: null;
1294: else

Line 1295: DELETE FROM ams_dm_org_contacts WHERE ARC_OBJECT_USED_BY = p_arc_object_for AND OBJECT_USED_BY_ID = p_object_for_id;

1291: -- DELETE FROM ams_dm_orgcont_stg_gt WHERE ARC_OBJECT_USED_BY = p_arc_object_for AND OBJECT_USED_BY_ID = p_object_for_id;
1292: if p_count = 'FINAL' and p_arc_object_for = G_OBJECT_TYPE_SCORE then
1293: null;
1294: else
1295: DELETE FROM ams_dm_org_contacts WHERE ARC_OBJECT_USED_BY = p_arc_object_for AND OBJECT_USED_BY_ID = p_object_for_id;
1296: end if;
1297: END IF;
1298:
1299: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_ams_schema || '.ams_dm_target_stg';

Line 1782: --kbasavar contents of ams_dm_org_contacts will be synchronized with the organizations in ams_dm_source

1778: END IF;
1779: END IF;
1780: END IF;
1781:
1782: --kbasavar contents of ams_dm_org_contacts will be synchronized with the organizations in ams_dm_source
1783: IF l_is_b2b AND l_model_type='CUSTOMER_PROFITABILITY' AND p_seeded_data_source THEN
1784: -- DELETE FROM ams_dm_org_contacts_stg
1785: -- DELETE FROM ams_dm_orgcont_stg_gt
1786: DELETE FROM ams_dm_org_contacts

Line 1784: -- DELETE FROM ams_dm_org_contacts_stg

1780: END IF;
1781:
1782: --kbasavar contents of ams_dm_org_contacts will be synchronized with the organizations in ams_dm_source
1783: IF l_is_b2b AND l_model_type='CUSTOMER_PROFITABILITY' AND p_seeded_data_source THEN
1784: -- DELETE FROM ams_dm_org_contacts_stg
1785: -- DELETE FROM ams_dm_orgcont_stg_gt
1786: DELETE FROM ams_dm_org_contacts
1787: -- WHERE org_party_id NOT IN (SELECT distinct party_id from ams_dm_inter_source_stg WHERE arc_object_used_by = p_arc_object_for AND
1788: WHERE org_party_id NOT IN (SELECT distinct party_id from ams_dm_int_src_stg_gt WHERE arc_object_used_by = p_arc_object_for AND

Line 1786: DELETE FROM ams_dm_org_contacts

1782: --kbasavar contents of ams_dm_org_contacts will be synchronized with the organizations in ams_dm_source
1783: IF l_is_b2b AND l_model_type='CUSTOMER_PROFITABILITY' AND p_seeded_data_source THEN
1784: -- DELETE FROM ams_dm_org_contacts_stg
1785: -- DELETE FROM ams_dm_orgcont_stg_gt
1786: DELETE FROM ams_dm_org_contacts
1787: -- WHERE org_party_id NOT IN (SELECT distinct party_id from ams_dm_inter_source_stg WHERE arc_object_used_by = p_arc_object_for AND
1788: WHERE org_party_id NOT IN (SELECT distinct party_id from ams_dm_int_src_stg_gt WHERE arc_object_used_by = p_arc_object_for AND
1789: object_used_by_id = p_object_for_id);
1790: