Extract DB Objects SQL

SELECT object_name,object_type,DBMS_METADATA.get_ddl (object_type, object_name)
 FROM dba_objects DV
WHERE 1=1
--and object_name LIKE 'IFL%'  
AND  object_name LIKE 'CUST%'
AND OWNER= 'APPS'
  AND object_type  IN('FUNCTION','PROCEDURE','PACKAGE','SEQUENCE','VIEW','TABLE')
    AND TRUNC(DV.CREATED) >= '01-MAY-2016'
UNION ALL

SELECT object_name,object_type,DBMS_METADATA.get_ddl (object_type, object_name)
 FROM dba_objects DV
WHERE 1=1
--and object_name LIKE 'IFL%'  
AND  object_name LIKE 'IFL%'
AND OWNER= 'APPS'
  AND object_type  IN(/*'FUNCTION','PROCEDURE',*/'PROCEDURE') --0,'SEQUENCE','VIEW','TABLE')
    AND TRUNC(DV.CREATED) >= '01-MAY-2016'  
   -- AND OBJECT_NAME NOT IN ( 'IFL_WCC_WF') ---,'I_OBJ#','TAB$')
 
 
SELECT PEC.CLASSIFICATION_NAME,
       PET.ELEMENT_NAME,
       PIV.NAME INVPUT_NAME,
       PEC.CLASSIFICATION_NAME,
       PET.PROCESSING_TYPE,
       PET.PROCESSING_PRIORITY      
 FROM PAY_ELEMENT_TYPES_X PET,
              PAY_INPUT_VALUES_X PIV,
                  pay_element_classifications pec
              WHERE  PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
              AND    PET.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID  ORDER BY 1 ASC
             
select  v.NAME,v.DATA_TYPE,fc.CONTEXT_NAME context_parameter,fc.DATA_TYPE   ,fp.NAME parameter ,fp.DATA_TYPE
from  FF_FUNCTIONS_V  v,
     FF_FUNCTION_CONTEXT_USAGES_V fc,
     FF_FUNCTION_PARAMETERS_V  fp
 where v.CREATED_BY in(1070,9877)
 and   fc.FUNCTION_ID (+) = v.FUNCTION_ID
 and   fp.FUNCTION_ID (+)= v.FUNCTION_ID
 order by 1


select  ff.FORMULA_NAME,        FF.FORMULA_TYPE_ID,
        ff.CREATED_BY ,
        ff.FORMULA_TEXT
        from      FF_FORMULAS_F ff
        where ff.CREATED_BY IN(1070,9877)
       
       

select  et.ELEMENT_NAME,
        ff.FORMULA_NAME ,
        frr.RESULT_NAME,
        piv.NAME input_name      
from    pay_element_types_f et,
        pay_input_values_f  piv,
        pay_status_processing_rules_f spr ,
        pay_formula_result_rules_f frr,
          FF_FORMULAS_F ff
where    spr.ELEMENT_TYPE_ID = et.ELEMENT_TYPE_ID
and      frr.STATUS_PROCESSING_RULE_ID = spr.STATUS_PROCESSING_RULE_ID
and      frr.ELEMENT_TYPE_ID   =  et.ELEMENT_TYPE_ID
and       spr.FORMULA_ID     = ff.FORMULA_ID
and       piv.ELEMENT_TYPE_ID  = et.ELEMENT_TYPE_ID
and       frr.INPUT_VALUE_ID   = piv.INPUT_VALUE_ID      


select  alt.ALERT_NAME,alt.ALERT_CONDITION_TYPE,fa.APPLICATION_SHORT_NAME,alt.SQL_STATEMENT_TEXT
from ALR_ALERTS  alt,
     fnd_application fa    
where alt.CREATED_BY in (1070,9877)  and alt.ENABLED_FLAG = 'Y'
and  fa.APPLICATION_ID = alt.APPLICATION_ID