DBA Data[Home] [Help]

APPS.AMS_DMSOURCE_PVT dependencies on AMS_DM_TARGETS_B

Line 2109: FROM ams_dm_targets_b target

2105: ;
2106:
2107: CURSOR c_target_field (p_target_id IN NUMBER) IS
2108: SELECT target.source_field_id
2109: FROM ams_dm_targets_b target
2110: WHERE target.target_id = p_target_id
2111: ;
2112:
2113: l_field VARCHAR2(151);

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