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_LIST_SRC_TYPES

Line 1342: FROM ams_list_src_types a , ams_discoverer_sql b

1338:
1339: CURSOR c_master_types (p_workbook_owner_name IN VARCHAR2, p_workbook_name IN VARCHAR2, p_worksheet_name IN VARCHAR2) IS
1340: SELECT a.source_type_code,
1341: a.source_object_name || '.' || a.source_object_pk_field
1342: FROM ams_list_src_types a , ams_discoverer_sql b
1343: WHERE a.master_source_type_flag = 'Y'
1344: AND a.enabled_flag = 'Y'
1345: AND b.workbook_owner_name = p_workbook_owner_name
1346: AND b.workbook_name = p_workbook_name

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 2878: FROM ams_list_src_types

2874: )
2875: IS
2876: CURSOR c_pk_field (p_list_source_type_id IN NUMBER) IS
2877: SELECT source_object_name || '.' || source_object_pk_field
2878: FROM ams_list_src_types
2879: WHERE list_source_type_id = p_list_source_type_id
2880: ;
2881:
2882: l_source_pk_field VARCHAR2(61);

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 2961: FROM ams_list_src_types a, ams_dm_target_sources 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,'')
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

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 3574: FROM ams_list_src_types a, ams_list_src_type_assocs b, ams_list_src_types c

3570: SELECT a.SOURCE_OBJECT_NAME as CHILD_SOURCE,
3571: b.SUB_SOURCE_TYPE_PK_COLUMN as CHILD_COLUMN,
3572: c.SOURCE_OBJECT_NAME as PARENT_SOURCE,
3573: NVL(b.MASTER_SOURCE_TYPE_PK_COLUMN , c.SOURCE_OBJECT_PK_FIELD) as PARENT_COLUMN
3574: FROM ams_list_src_types a, ams_list_src_type_assocs b, ams_list_src_types c
3575: where b.MASTER_SOURCE_TYPE_ID = p_master_ds_id
3576: and b.SUB_SOURCE_TYPE_ID = p_child_ds_id
3577: and b.ENABLED_FLAG = 'Y'
3578: and a.LIST_SOURCE_TYPE_ID=b.SUB_SOURCE_TYPE_ID

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 3636: FROM ams_dm_target_sources t,ams_list_src_types d

3632: AND t.DATA_SOURCE_ID=d.LIST_SOURCE_TYPE_ID
3633: AND d.SOURCE_TYPE_CODE = 'AMS_DM_PARTY_ATTRIBUTES_V'
3634: UNION
3635: SELECT 1
3636: FROM ams_dm_target_sources t,ams_list_src_types d
3637: WHERE t.target_id = p_target_id
3638: AND t.DATA_SOURCE_ID=d.LIST_SOURCE_TYPE_ID
3639: AND d.SOURCE_TYPE_CODE = 'AMS_DM_PARTY_ATTRIBUTES_V'
3640: ;

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: