GET DDLs from ORACLE
To Get Table Structure :
---- For Table Structure
select tname ,dbms_metadata.get_ddl('TABLE',TNAME,'APPS')
from tab a
where tname like 'SEL%'
and a.TABTYPE ='TABLE'
To Get View Structure :
---- For View Structure
select tname ,dbms_metadata.get_ddl('VIEW',TNAME,'APPS')
from tab a
where tname like 'SEL%'
and a.TABTYPE ='VIEW'
OR To Get View, Table, Function, Procedure Structure :
select OWNER, OBJECT_TYPE , OBJECT_NAME ,dbms_metadata.get_ddl(OBJECT_TYPE, OBJECT_NAME ,OWNER)
from DBA_OBJECTS a
where OBJECT_NAME like '%MNJ%'
and OBJECT_TYPE in ('VIEW' ,'TABLE','FUNCTION','PROCEDURE')
To Get Personalizations :
---- For Personalization
select * from fnd_form_custom_rules ffcr,fnd_form_custom_actions ffca
where ffcr.id=ffca.RULE_ID
--and id=2242
To Get FAST FORMULAS :
---- For Formulas
select * from FF_FORMULAS_F
where FORMULA_NAME like 'RCL%'
To Get PLSQL Data :
--- For PLSQL Data
select * from dba_source
where name like 'SEL%'
