What are the values held in FOREIGN_KEYS_RELATION ?

Mark Ireland

Hi,

We are currently trying to pull out all the foreign keys in the EBS system so that we can build up a datamap.

We have managed to get names, colums etc etc but we are lacking the relationship carnality between parents and children.

All we have managed is to extract the field FOREIGN_KEYS_RELATION from the table FND_FOREIGN_KEYS, this is simply giving us a single character.

E.G L, S D etc.

Does anybody know what these mean? or how we find out the carnality between tables?

To clarify, the end result we want is a CSV file showing us:-

FK_name,     Parent Schema,     Parent Table,     Parent carnality,     Child Schema,     Child Table,     Child carnality,      Parent column,     Child column.

Just in case we are barking up the wrong tree,

Many thanks

Mark.