APPS.AMS_ADV_FILTER_PVT dependencies on AMS_LIST_SRC_TYPES
Line 1082: FROM ams_list_src_fields_vl a , ams_list_src_types b , ams_list_src_types d
1078: */
1079:
1080: CURSOR c_fieldName(l_fieldId IN NUMBER , p_ds_id IN NUMBER) IS
1081: SELECT b.source_object_name || '.' || a.source_column_name 1082: FROM ams_list_src_fields_vl a , ams_list_src_types b , ams_list_src_types d 1083: WHERE a.list_source_field_id = l_fieldId
1084: AND a.list_source_type_id = b.list_source_type_id
1085: AND d.list_source_type_id = p_ds_id
1086: AND d.enabled_flag = 'Y'