1 - Find out in what table is a custom object been stored.

        
            select *
            from fusion.adf_extensible_table_usage
            where ENTITYDEF_FULLNAME like '%customobject_api_name%'
        
        
        
        

2- Find the Table in which the custom object is held

        
            SELECT TABLE_NAME FROM fusion.adf_extensible_table 
            WHERE TABLE_ID = 
            SELECT
            *
            FROM fusion.adf_extensible_table
            WHERE TABLE_ID IN (SELECT
            TABLE_ID
            FROM fusion.adf_extensible_table_usage
            WHERE ENTITYDEF_FULLNAME LIKE '%customobject_api_name%')
        
        
        
        

3 - Find out in what columns are custom fields that are on a custom object

        
            SELECT OBJECT_NAME AS OBJECT, 
            OBJECT_ATTR_NAME AS ATRRIBUTE,
            OBJECT_ATTR_LEN AS LENGTH, 
            SUBSTR(OBJECT_ATTR_TYPE, -INSTR(REVERSE(OBJECT_ATTR_TYPE), '.') + 1) AS DATA_TYPE, 
            TXN_VO_ATTR_TABLE, TXN_VO_ATTR_COL 
            FROM FUSION.MKT_IMP_OBJECT_DETAILS D, FUSION.MKT_IMP_OBJECT_ATTRS A 
            WHERE D.OBJECT_DETAIL_ID = A.OBJECT_DETAIL_ID 
            AND A.OBJECT_ATTR_COL LIKE '%EXTN_ATTRIBUTE%' 
            AND A.CREATED_BY != 'SEED_DATA_FROM_APPLICATION' 
            AND D.OBJECT_DETAIL_TABLE != 'MKT_IMP_JOBS' 
            AND OBJECT_NAME LIKE '%%'
        
        
        
        

4 - See the records in the custom object

        
        select * from 
        where attribute_category =''
        DATABASE_OBJECT_NAME - results of query 3
        OBJ_NAME - results of query 3