Register a View as Table with Oracle Applications

/* In the below commands replace XXXX with the custom schema name where the view is created*/

CREATE OR REPLACE VIEW XXXX_Product_view AS (SELECT DISTINCT segment5 PRODUCT FROM gl_code_combinations);

CREATE OR REPLACE PUBLIC SYNONYM XXXX_PRODUCT FOR XXXX_Product_view;

EXEC ad_dd.register_table('XXXX','XXXX_PRODUCT','T');

EXEC ad_dd.register_column('XXXX','XXXX_PRODUCT','PRODUCT',1,'Varchar2',30,'N','N');