FANDOM


Find all Banner APIs by tableEdit

This SQL will return all the tables for which an API is available.

SELECT owner,
       table_name,
       gb_common.F_GET_API_NAME(owner,table_name)

FROM   all_tables

WHERE  gb_common.F_GET_API_NAME(owner,table_name) IS NOT NULL;

Find a Banner API for a specific tableEdit

This SQL will return the API for a specific table, if any.

SELECT gb_common.F_GET_API_NAME('OWNER','TABLE_NAME')

FROM dual;

... where OWNER and TABLE_NAME are the desired values.