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_MODELS_ALL_B

Line 508: FROM ams_dm_models_all_b

504: L_SEEDED_ID_THRESHOLD CONSTANT NUMBER := 10000;
505:
506: CURSOR c_model (p_model_id IN NUMBER) IS
507: SELECT target_id
508: FROM ams_dm_models_all_b
509: WHERE model_id = p_model_id
510: ;
511:
512: CURSOR c_score (p_score_id IN NUMBER) IS

Line 514: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model

510: ;
511:
512: CURSOR c_score (p_score_id IN NUMBER) IS
513: SELECT model.target_id
514: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model
515: WHERE score.score_id = p_score_id
516: AND model.model_id = score.model_id
517: ;
518:

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 1433: FROM ams_dm_models_all_b

1429: l_sources_rec c_sources%ROWTYPE;
1430:
1431: CURSOR c_target_value (p_model_id IN NUMBER) IS
1432: SELECT target_positive_value
1433: FROM ams_dm_models_all_b
1434: WHERE model_id = p_model_id
1435: ;
1436:
1437: CURSOR c_recs IS

Line 1449: FROM ams_dm_models_all_b

1445: ;
1446:
1447: CURSOR c_model_status (p_model_id IN NUMBER) IS
1448: SELECT status_code
1449: FROM ams_dm_models_all_b
1450: WHERE model_id = p_model_id;
1451:
1452: CURSOR c_score_status (p_score_id IN NUMBER) IS
1453: SELECT status_code

Line 1498: UPDATE ams_dm_models_all_b

1494: OPEN c_target_value (p_object_for_id);
1495: FETCH c_target_value INTO l_target_value;
1496: CLOSE c_target_value;
1497:
1498: UPDATE ams_dm_models_all_b
1499: SET total_records = 0,
1500: total_positives = 0
1501: WHERE model_id = p_object_for_id
1502: ;

Line 1738: UPDATE ams_dm_models_all_b

1734: OPEN c_recs;
1735: FETCH c_recs INTO l_total_records, l_total_positives;
1736: CLOSE c_recs;
1737:
1738: UPDATE ams_dm_models_all_b
1739: SET total_records = l_total_records
1740: , total_positives = l_total_positives
1741: WHERE model_id = p_object_for_id
1742: ;

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 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 2633: FROM ams_dm_models_all_b

2629: max_records,
2630: row_selection_type,
2631: every_nth_row,
2632: pct_random
2633: FROM ams_dm_models_all_b
2634: WHERE model_id = p_model_id
2635: ;
2636: CURSOR c_score_details (p_score_id IN NUMBER) IS
2637: SELECT min_records,

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 3069: FROM ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst

3065: ;
3066:
3067: CURSOR c_model_child_ds (p_model_id IN NUMBER) IS
3068: SELECT source.data_source_id
3069: FROM ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst
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'

Line 3083: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst

3079: ;
3080:
3081: CURSOR c_score_child_ds (p_score_id IN NUMBER) IS
3082: SELECT source.data_source_id
3083: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst
3084: WHERE score.score_id = p_score_id
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

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