DBA Data[Home] [Help]

APPS.GMA_PURGE_ENGINE dependencies on DBA_USERS

Line 447: , dba_users UU

443: , UC.data_type drowtype
444: , decode(nvl(SD.archive_action,'K'),'D','D','K') arcaction
445: , UU.default_tablespace arctablespace
446: FROM all_tab_columns UC
447: , dba_users UU
448: , sy_purg_def_act SD
449: , sy_purg_def SP
450: WHERE UC.owner = c_schema_name
451: AND UU.USERNAME='GMA'

Line 626: FROM dba_users UU

622: , nvl(SM.disable_constraints_flag,'F') disable_constraints
623: , nvl(SM.calculate_storage_flag,'F') storage_flag
624: , nvl(SM.commit_frequency,750) commit_frequency
625: , nvl(SM.object_owner,'') object_owner
626: FROM dba_users UU
627: , sy_purg_mst SM
628: , sy_purg_def SD
629: WHERE SD.purge_type (+) = SM.purge_type
630: AND UU.username = 'GMA'