APPS.AMS_ADV_FILTER_PVT dependencies on AMS_LIST_SRC_FIELDS_VL

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'

Line 1303: FROM ams_list_src_fields_vl

1299: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1300:
1301: CURSOR c_fieldId(p_fieldName IN VARCHAR2 , p_ds_id IN NUMBER) IS
1302: SELECT to_char(list_source_field_id)
1303: FROM ams_list_src_fields_vl
1304: WHERE source_column_name = SUBSTR(p_fieldName , INSTR(p_fieldName , '.') + 1)
1305: AND list_source_type_id = p_ds_id
1306: ;
1307: l_fieldName VARCHAR2(60);