Friday, February 22, 2013

Searching FND Lookup Type for a given set of Lookup Codes

Few times we see the LOOKUP CODE being used in Oracle tables and we can see few distinct values but we do not know the the lookup type for those values. eTRM is not very helpful. In such case, following query can help.

This query returns the list of lookup types that have two lookup code 'M' and 'F'. This query can be modified to check existence of few other lookup codes

No comments:

Post a Comment