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_TYPE_ASSOCS

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