DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_TSDATA dependencies on DBA_TAB_COLUMNS

Line 40: select col.column_name from user_synonyms syn, dba_tab_columns col where

36: l_oracle_schema VARCHAR2 (30);
37:
38: --bug 15835553
39: CURSOR c_varchar_cols_cur(l_table_name varchar2, l_owner VARCHAR2) is
40: select col.column_name from user_synonyms syn, dba_tab_columns col where
41: col.owner=syn.table_owner AND col.table_name = syn.table_name
42: and syn.synonym_name = l_table_name and col.owner = l_owner and col.data_type in ( 'VARCHAR2' , 'CHAR');
43:
44: CURSOR c_item_valid (cp_n_item_id IN NUMBER, cp_n_org_id IN NUMBER) IS