Siebel IP 19 - SQL statement for pull data for List of values

Hi,

 

We recently migrated from IP16 to IP19.9.

 

We have crystal reports, that pulls Siebel data through SQL statements.

 

We came across, an issue where the S_LST_OF_VAL had duplicate data in the database.

On further analysis we identified that, the duplicates were because of multiple migration done from dev to test environment.

 

As from Siebel IP 17+, onwards all the LOV's are workspace driven (tied to workspaces), there were duplicates in the database.

 

For example:

SQL in IP16 (current production):

SELECT B.ROW_ID, B.DESC_TEXT, B.VAL

  FROM S_LST_OF_VAL B

WHERE B.TYPE='CTC_EXAM_NAME'