DBA Data[Home] [Help]

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'