BI Publisher – Get LOOKUP VALUES
SELECT
ENTERPRISE_ID,
LOOKUP_TYPE,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_B
WHERE LOOKUP_TYPE = '{SomeValue}'
SELECT
ENTERPRISE_ID,
LOOKUP_TYPE,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_B
WHERE LOOKUP_TYPE = '{SomeValue}'