DBA Data[Home] [Help]

APPS.GMA_PURGE_ENGINE dependencies on ALL_TAB_COLUMNS

Line 446: FROM all_tab_columns UC

442: SELECT UC.column_name arctable
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

Line 469: , all_tab_columns UC

465: ) arctablespace
466: FROM user_users UU
467: , sy_purg_def_act SD
468: , sy_purg_def SP
469: , all_tab_columns UC
470: WHERE UC.owner='GMA'
471: AND SD.purge_type = SP.purge_type
472: AND SD.table_name = UC.column_name
473: AND SP.purge_type = c_purge_type

Line 478: -- Changed by Khaja user_tab_columns TO all_tab_columns

474: AND UC.table_name = c_arctablename
475: ORDER BY UC.column_id;
476: */
477:
478: -- Changed by Khaja user_tab_columns TO all_tab_columns
479: l_badrowtype EXCEPTION;
480: l_tablecount INTEGER;
481: l_schema_name VARCHAR2(30); /* Bug 4344986 */
482: