[Home] [Help]
2288: --were used to define the de-duplication rule
2289: CURSOR c_rule_field(cur_rule_id number) is
2290: SELECT b.field_column_name
2291: FROM ams_list_rule_fields a,
2292: ams_list_src_fields b
2293: WHERE a.list_rule_id = cur_rule_id
2294: AND a.LIST_SOURCE_FIELD_ID = b.LIST_SOURCE_FIELD_ID;
2295:
2296: --this will check if the Data Source's Uniq. Id is mapped
2296: --this will check if the Data Source's Uniq. Id is mapped
2297: --to the PARTY_ID column in ams_list_ensties
2298: CURSOR c_check_DS_PK_mapping(l_source_type VARCHAR2) is
2299: SELECT 1
2300: FROM ams_list_src_fields f,
2301: ams_list_src_types t
2302: WHERE t.LIST_SOURCE_TYPE_ID = f.LIST_SOURCE_TYPE_ID
2303: AND f.FIELD_COLUMN_NAME = 'PARTY_ID'
2304: AND f.SOURCE_COLUMN_NAME = t.SOURCE_OBJECT_PK_FIELD
2617: l_tca_field_mapped varchar2(1);
2618:
2619: cursor c_master_ds_tca_mapped(list_head_id IN NUMBER)
2620: IS
2621: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty
2622: where hd.list_header_id = list_head_id
2623: and hd.LIST_SOURCE_TYPE = ty.source_type_code
2624: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
2625: and fd.tca_column_id is NOT NULL;
3394: SELECT b.field_column_name ,
3395: c.source_object_name,
3396: b.source_column_name
3397: BULK COLLECT INTO :1 ,:2 ,:3
3398: FROM ams_list_src_fields b, ams_list_src_types c
3399: WHERE b.list_source_type_id = c.list_source_type_id
3400: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
3401: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
3402: FROM ams_list_src_fields a
3398: FROM ams_list_src_fields b, ams_list_src_types c
3399: WHERE b.list_source_type_id = c.list_source_type_id
3400: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
3401: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
3402: FROM ams_list_src_fields a
3403: WHERE a.field_column_name= b.field_column_name
3404: AND a.DE_LIST_SOURCE_TYPE_CODE IN '
3405: || l_data_source_types || ') ;
3406: END; '