DBA Data[Home] [Help]

APPS.HZ_MIXNM_REGISTRY_PUB dependencies on ALL_TAB_COLUMNS

Line 900: from sys.all_tab_columns c

896: where b.object_name = 'HZ_PARTY_V2PUB'
897: and b.owner = p_apps_schema
898: and b.object_type = 'PACKAGE')) temp1, (
899: select column_name
900: from sys.all_tab_columns c
901: where c.table_name = 'HZ_PARTIES'
902: and c.owner = p_ar_schema
903: and exists (
904: select null

Line 905: from sys.all_tab_columns c2

901: where c.table_name = 'HZ_PARTIES'
902: and c.owner = p_ar_schema
903: and exists (
904: select null
905: from sys.all_tab_columns c2
906: where c2.owner = p_ar_schema
907: and c2.column_name = c.column_name
908: and c2.table_name = 'HZ_' ||upper (p_name) || '_PROFILES')
909: and c.column_name not like 'ATTRIBUTE%'