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_TARGETS_B

Line 824: FROM ams_dm_models_all_b model, ams_dm_targets_b target

820: l_workbook_rec c_workbook%ROWTYPE;
821:
822: CURSOR c_model (p_model_id IN NUMBER) IS
823: SELECT target.data_source_id , target.target_id
824: FROM ams_dm_models_all_b model, ams_dm_targets_b target
825: WHERE model.model_id = p_model_id
826: AND target.target_id = model.target_id
827: ;
828:

Line 831: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_targets_b target

827: ;
828:
829: CURSOR c_score (p_score_id IN NUMBER) IS
830: SELECT target.data_source_id , target.target_id
831: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_targets_b target
832: WHERE score.score_id = p_score_id
833: AND model.model_id = score.model_id
834: AND target.target_id = model.target_id
835: ;

Line 1912: FROM ams_dm_models_all_b m, ams_dm_targets_b t

1908: , m.model_type
1909: , m.target_positive_value
1910: , t.target_id
1911: , t.data_source_id
1912: FROM ams_dm_models_all_b m, ams_dm_targets_b t
1913: WHERE m.model_id = p_model_id
1914: AND t.target_id = m.target_id
1915: ;
1916: l_model_rec c_model_details%ROWTYPE;

Line 1928: FROM ams_dm_targets_b target, ams_list_src_fields field, ams_list_src_types source1, ams_list_src_types source2

1924: , source2.source_object_name||decode(UPPER(source2.remote_flag),'Y','@'||source2.database_link,'')
1925: , target.data_source_id
1926: , target.target_source_id
1927: , field.enabled_flag
1928: FROM ams_dm_targets_b target, ams_list_src_fields field, ams_list_src_types source1, ams_list_src_types source2
1929: WHERE target.target_id = p_target_id
1930: AND field.list_source_field_id = source_field_id
1931: AND source2.list_source_type_id = target.data_source_id
1932: AND source1.list_source_type_id = target.target_source_id

Line 2429: FROM ams_dm_models_all_b m, ams_dm_targets_b t

2425: , m.model_type
2426: , m.target_positive_value
2427: , t.target_id
2428: , t.data_source_id
2429: FROM ams_dm_models_all_b m, ams_dm_targets_b t
2430: WHERE m.model_id = p_model_id
2431: AND t.target_id = m.target_id
2432: ;
2433: l_object_rec c_model_details%ROWTYPE;

Line 2441: FROM ams_dm_models_all_b m, ams_dm_scores_all_b s, ams_dm_targets_b t

2437: , m.model_type
2438: , m.target_positive_value
2439: , t.target_id
2440: , t.data_source_id
2441: FROM ams_dm_models_all_b m, ams_dm_scores_all_b s, ams_dm_targets_b t
2442: WHERE m.model_id = s.model_id
2443: AND s.score_id = p_score_id
2444: AND t.target_id = m.target_id
2445: ;

Line 2956: FROM ams_list_src_types a, ams_dm_targets_b b

2952: L_FROM_OFFSET CONSTANT NUMBER := 5;
2953:
2954: CURSOR c_source_object (p_target_id IN NUMBER) IS
2955: SELECT a.source_object_name||decode(UPPER(a.remote_flag),'Y','@'||a.database_link,'')
2956: FROM ams_list_src_types a, ams_dm_targets_b b
2957: WHERE a.list_source_type_id = b.data_source_id
2958: AND b.target_id = p_target_id
2959: UNION
2960: SELECT a.source_object_name||decode(UPPER(a.remote_flag),'Y','@'||a.database_link,'')

Line 2965: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs c,ams_dm_targets_b d

2961: FROM ams_list_src_types a, ams_dm_target_sources b
2962: WHERE a.list_source_type_id = b.data_source_id
2963: AND a.enabled_flag = 'Y'
2964: AND b.target_id = p_target_id
2965: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs c,ams_dm_targets_b d
2966: WHERE d.target_id = p_target_id
2967: AND c.MASTER_SOURCE_TYPE_ID = d.data_source_id
2968: AND c.SUB_SOURCE_TYPE_ID = b.data_source_id
2969: AND c.enabled_flag = 'Y')

Line 3060: FROM ams_dm_models_all_b model, ams_dm_targets_b target, ams_list_src_fields field , ams_list_src_types ds

3056: L_WHERE_OFFSET CONSTANT NUMBER := 6;
3057:
3058: CURSOR c_target_field (p_model_id IN NUMBER) IS
3059: SELECT ds.source_object_name || '.' || field.source_column_name
3060: FROM ams_dm_models_all_b model, ams_dm_targets_b target, ams_list_src_fields field , ams_list_src_types ds
3061: WHERE model.model_id = p_model_id
3062: AND target.target_id = model.target_id
3063: AND field.list_source_field_id = target.source_field_id
3064: AND ds.list_source_type_id = target.target_source_id

Line 3074: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs c,ams_dm_targets_b d

3070: WHERE model.model_id = p_model_id
3071: AND source.target_id = model.target_id
3072: AND lst.list_source_type_id = source.data_source_id
3073: AND lst.enabled_flag = 'Y'
3074: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs c,ams_dm_targets_b d
3075: WHERE d.target_id = model.target_id
3076: AND c.MASTER_SOURCE_TYPE_ID = d.data_source_id
3077: AND c.SUB_SOURCE_TYPE_ID = source.data_source_id
3078: AND c.enabled_flag = 'Y')

Line 3089: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs c,ams_dm_targets_b d

3085: AND model.model_id = score.model_id
3086: AND source.target_id = model.target_id
3087: AND lst.list_source_type_id = source.data_source_id
3088: AND lst.enabled_flag = 'Y'
3089: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs c,ams_dm_targets_b d
3090: WHERE d.target_id = model.target_id
3091: AND c.MASTER_SOURCE_TYPE_ID = d.data_source_id
3092: AND c.SUB_SOURCE_TYPE_ID = source.data_source_id
3093: AND c.enabled_flag = 'Y')

Line 3500: FROM ams_dm_models_all_b m,ams_dm_targets_b t,ams_list_src_types d

3496:
3497: CURSOR c_data_source (p_model_id IN NUMBER) IS
3498: --SELECT d.SOURCE_TYPE_CODE
3499: SELECT d.SOURCE_CATEGORY
3500: FROM ams_dm_models_all_b m,ams_dm_targets_b t,ams_list_src_types d
3501: WHERE m.model_id = p_model_id
3502: AND m.target_id = t.target_id
3503: AND t.DATA_SOURCE_ID=d.LIST_SOURCE_TYPE_ID;
3504:

Line 3630: FROM ams_dm_targets_b t,ams_list_src_types d

3626: L_API_NAME VARCHAR2(30) := 'is_target_attached_to_seeded';
3627:
3628: CURSOR c_data_source (p_target_id IN NUMBER) IS
3629: SELECT 1
3630: FROM ams_dm_targets_b t,ams_list_src_types d
3631: WHERE t.target_id = p_target_id
3632: AND t.DATA_SOURCE_ID=d.LIST_SOURCE_TYPE_ID
3633: AND d.SOURCE_TYPE_CODE = 'AMS_DM_PARTY_ATTRIBUTES_V'
3634: UNION

Line 3680: FROM ams_dm_models_all_b m,ams_dm_targets_b t,ams_list_src_types d

3676: L_API_NAME VARCHAR2(30) := 'Is Org Prod Affinity';
3677:
3678: CURSOR c_data_source_type_code (p_model_id IN NUMBER) IS
3679: SELECT d.source_type_code
3680: FROM ams_dm_models_all_b m,ams_dm_targets_b t,ams_list_src_types d
3681: WHERE m.model_id = p_model_id
3682: AND m.target_id = t.target_id
3683: AND t.data_source_id=d.list_source_type_id;
3684: