APPS.ASG_CUSTOM_PVT dependencies on ALL_TAB_COLUMNS

Line 220: from all_tab_columns

216: l_new_query := l_new_query ||generate_query(p_data_columns,l_pk_num+1);
217:
218: -- get the number of the columns in piv
219: select count(*) into l_cols_count
220: from all_tab_columns
221: where table_name = l_piv_name
222: and owner=APPS_SCHEMA_NAME;
223:
224: -- and owner = (select owner

Line 225: -- from all_tab_columns

221: where table_name = l_piv_name
222: and owner=APPS_SCHEMA_NAME;
223:
224: -- and owner = (select owner
225: -- from all_tab_columns
226: -- where table_name = l_piv_name
227: -- and rownum=1);
228:
229: log('total number of the column in the base view:'||to_char(l_cols_count));

Line 245: from all_tab_columns

241: Else
242: -- IF (IS_BLOB_INCLUDED ='Y') THEN
243: -- check to make sure the input put item is the right one
244: select data_type into c_type
245: from all_tab_columns
246: where table_name = l_piv_name
247: and column_name = 'ATTRIBUTE'||to_char(l_cols_count-1)
248: and rownum = 1 and owner=APPS_SCHEMA_NAME;
249: if (c_type <> 'BLOB') then

Line 404: from all_tab_columns

400: l_col varchar2(2000);
401:
402: BEGIN
403: select data_type into l_type
404: from all_tab_columns
405: where table_name = B_TAB_NAME
406: and column_name = col
407: and rownum = 1 and owner=APPS_SCHEMA_NAME;
408: