APPS.HZ_MIXNM_REGISTRY_PUB dependencies on DBA_TAB_COLUMNS

Line 917: , dba_tab_columns col

913: and c.column_name not in ('APPLICATION_ID')
914: */
915: select col.column_name
916: from user_synonyms syn
917: , dba_tab_columns col
918: where syn.synonym_name = 'HZ_PARTIES'
919: and col.owner = syn.table_owner
920: and col.table_name = syn.table_name
921: and exists (

Line 924: , dba_tab_columns col2

920: and col.table_name = syn.table_name
921: and exists (
922: select null
923: from user_synonyms syn
924: , dba_tab_columns col2
925: where col2.owner = syn.table_owner
926: and col2.table_name = syn.table_name
927: and col.column_name = col2.column_name
928: and syn.synonym_name = 'HZ_' ||upper (p_name) || '_PROFILES')