select * from fnd_tables where table_name like '%SECOM%'
select * from fnd_columns where table_id=88035
select * from fnd_application
AD_DD.REGISTER_TABLE('SECOM','SECOM_SBC_LISTS','T',2,10,40);
AD_DD.REGISTER_COLUMN('SECOM','SECOM_SBC_LISTS','FLEXFIELD_DEMO_ID',1,'NUMBER',38,'Y','N');
select tc.table_name, tc.column_name ,row_number() over(partition by tc.table_name order by column_id) rn
,' AD_DD.REGISTER_COLUMN(''SECOM'',''SECOM_SBC_LISTS'','''|| tc.column_name ||''','||
to_char( row_number() over(partition by tc.table_name order by column_id) )
||','''|| tc.DATA_TYPE ||''',38,''Y'',''N''); '
from all_tab_columns tc
where tc.owner=upper('secom') and tc.table_name=upper('SECOM_SBC_LISTS')
