DBA Data[Home] [Help]

APPS.AMS_DMSELECTION_PVT dependencies on AMS_DM_TARGET_VALUES_B

Line 2081: l_sql := l_sql || ' FROM ams_dm_target_values_b tv, ' || l_target_source_object_full;

2077: l_sql := l_sql || ' SET t.target_flag = (SELECT ''' || L_POSITIVE_TARGET_VALUE || '''';
2078: l_sql := l_sql || ' FROM dual WHERE EXISTS (SELECT 1';
2079:
2080: IF l_data_source_id = l_target_source_id THEN
2081: l_sql := l_sql || ' FROM ams_dm_target_values_b tv, ' || l_target_source_object_full;
2082: ELSE
2083: l_sql := l_sql || ' FROM ams_dm_target_values_b tv, ' || l_target_source_object_full || ', ' || l_pk_source_object_full;
2084: END IF;
2085:

Line 2083: l_sql := l_sql || ' FROM ams_dm_target_values_b tv, ' || l_target_source_object_full || ', ' || l_pk_source_object_full;

2079:
2080: IF l_data_source_id = l_target_source_id THEN
2081: l_sql := l_sql || ' FROM ams_dm_target_values_b tv, ' || l_target_source_object_full;
2082: ELSE
2083: l_sql := l_sql || ' FROM ams_dm_target_values_b tv, ' || l_target_source_object_full || ', ' || l_pk_source_object_full;
2084: END IF;
2085:
2086: l_sql := l_sql || ' WHERE tv.target_id = :target_id';
2087:

Line 3382: -- target values defined in AMS_DM_TARGET_VALUES_B along with

3378: -- Get Target Positive Values
3379: --
3380: -- Note:
3381: -- A Data Mining Target field may have multiple positive
3382: -- target values defined in AMS_DM_TARGET_VALUES_B along with
3383: -- value comparison conditions. For example, the target column
3384: -- is considered positive if it is >= 10 AND <= 20
3385: -- This procedure constructs the sql statement that combines all
3386: -- positive values defined for the target..

Line 3406: FROM ams_dm_target_values_b

3402: CURSOR c_target (p_target_id IN NUMBER) IS
3403: SELECT target_value,
3404: target_operator,
3405: range_value
3406: FROM ams_dm_target_values_b
3407: WHERE target_id = p_target_id;
3408:
3409: l_target_rec c_target%ROWTYPE;
3410: