DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_TSDATA dependencies on ALL_TAB_COLUMNS

Line 40: FROM all_tab_columns

36: l_oracle_schema VARCHAR2 (30);
37:
38: CURSOR c_varchar_cols_cur(l_table_name varchar2, l_owner VARCHAR2) is
39: SELECT column_name
40: FROM all_tab_columns
41: WHERE table_name = l_table_name
42: AND owner = l_owner
43: AND data_type in ( 'VARCHAR2' , 'CHAR');
44:

Line 161: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). For accessing all_tab_columns

157: */
158:
159: /* Start of Scripts for Item tables */
160: /* Get the application installation info. References to Data Dictionary Objects without schema name
161: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). For accessing all_tab_columns
162: in cursor c_varchar_cols_cur we need to pass the schema name*/
163:
164: l_ret_status := fnd_installation.get_app_info ('INV'
165: , l_status

Line 790: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). For accessing all_tab_columns

786:
787: /* Start of Scripts to check for trailing spaces in Bom Tables */
788:
789: /* Get the application installation info. References to Data Dictionary Objects without schema name
790: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). For accessing all_tab_columns
791: in cursor c_varchar_cols_cur we need to pass the schema name*/
792:
793: l_ret_status := fnd_installation.get_app_info ('BOM'
794: , l_status