Find Banner APIs

Find all Banner APIs by table
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 table
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.