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_DMSOURCE_PVT dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 2031: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa

2027: FROM ams_list_src_fields lsf , ams_list_src_types lst
2028: WHERE (lst.list_source_type_id = p_data_source_id
2029: OR lst.list_source_type_id IN
2030: (SELECT dts.data_source_id
2031: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa
2032: WHERE dts.target_id = p_target_id
2033: AND lsa.sub_source_type_id = dts.data_source_id
2034: AND lsa.master_source_type_id = p_data_source_id
2035: AND lsa.enabled_flag = 'Y')

Line 2053: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa

2049: FROM ams_list_src_fields lsf , ams_list_src_types lst
2050: WHERE (lst.list_source_type_id = p_data_source_id
2051: OR lst.list_source_type_id IN
2052: (SELECT dts.data_source_id
2053: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa
2054: WHERE dts.target_id = p_target_id
2055: AND lsa.sub_source_type_id = dts.data_source_id
2056: AND lsa.master_source_type_id = p_data_source_id
2057: AND lsa.enabled_flag = 'Y')

Line 2074: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa

2070: SELECT lsf.source_column_name
2071: FROM ams_list_src_fields lsf , ams_list_src_types lst
2072: WHERE lst.list_source_type_id IN
2073: (SELECT dts.data_source_id
2074: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa
2075: WHERE dts.target_id = p_target_id
2076: AND lsa.sub_source_type_id = dts.data_source_id
2077: AND lsa.master_source_type_id = p_data_source_id
2078: AND lsa.enabled_flag = 'Y')

Line 2094: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa

2090: SELECT lst.source_object_name || '.' || lsf.source_column_name
2091: FROM ams_list_src_fields lsf , ams_list_src_types lst
2092: WHERE lst.list_source_type_id IN
2093: (SELECT dts.data_source_id
2094: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa
2095: WHERE dts.target_id = p_target_id
2096: AND lsa.sub_source_type_id = dts.data_source_id
2097: AND lsa.master_source_type_id = p_data_source_id
2098: AND lsa.enabled_flag = 'Y')

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

2283: FROM ams_list_src_types a, ams_dm_target_sources b
2284: WHERE a.list_source_type_id = b.data_source_id
2285: AND a.enabled_flag = 'Y'
2286: AND b.target_id = p_target_id
2287: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs c,ams_dm_targets_b d
2288: WHERE d.target_id = p_target_id
2289: AND c.MASTER_SOURCE_TYPE_ID = d.data_source_id
2290: AND c.SUB_SOURCE_TYPE_ID = b.data_source_id
2291: AND c.enabled_flag = 'Y')