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_TYPES

Line 1585: FROM AMS_LIST_SRC_TYPES

1581: ;
1582:
1583: CURSOR c_ds_pk_field (p_data_source_id IN NUMBER) IS
1584: SELECT SOURCE_OBJECT_NAME || '.' || SOURCE_OBJECT_PK_FIELD
1585: FROM AMS_LIST_SRC_TYPES
1586: WHERE LIST_SOURCE_TYPE_ID = p_data_source_id
1587: ;
1588:
1589: CURSOR c_model_type(p_model_id IN NUMBER) is

Line 2027: FROM ams_list_src_fields lsf , ams_list_src_types lst

2023: )
2024: IS
2025: CURSOR c_dup_fields (p_data_source_id IN NUMBER, p_target_field IN NUMBER, p_target_id IN NUMBER) IS
2026: SELECT lsf.source_column_name
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

Line 2049: FROM ams_list_src_fields lsf , ams_list_src_types lst

2045: ;
2046:
2047: CURSOR c_fields (p_data_source_id IN NUMBER, p_target_field IN NUMBER, p_target_id IN NUMBER) IS
2048: SELECT lst.source_object_name || '.' || lsf.source_column_name
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

Line 2071: FROM ams_list_src_fields lsf , ams_list_src_types lst

2067: ;
2068:
2069: CURSOR c_dup_fields_custprof (p_data_source_id IN NUMBER, p_target_field IN NUMBER, p_target_id IN NUMBER) IS
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

Line 2091: FROM ams_list_src_fields lsf , ams_list_src_types lst

2087: ;
2088:
2089: CURSOR c_fields_custprof (p_data_source_id IN NUMBER, p_target_field IN NUMBER, p_target_id IN NUMBER) IS
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

Line 2258: FROM ams_list_src_types

2254: CURSOR c_data_source (p_data_source_id IN NUMBER) IS
2255: SELECT source_object_name
2256: , source_object_name||decode(UPPER(remote_flag),'Y','@'||database_link,'')
2257: , source_object_pk_field
2258: FROM ams_list_src_types
2259: WHERE list_source_type_id = p_data_source_id
2260: ;
2261:
2262: l_object_name VARCHAR2(30);

Line 2283: FROM ams_list_src_types a, ams_dm_target_sources b

2279: l_target_id NUMBER;
2280:
2281: CURSOR c_child_sources (p_target_id IN NUMBER) IS
2282: SELECT a.source_object_name , a.source_object_name||decode(UPPER(a.remote_flag),'Y','@'||a.database_link,''), a.list_source_type_id
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