APPS.ASG_CUSTOM_PVT dependencies on DBA_TAB_COLUMNS

Line 229: FROM all_synonyms syn, dba_tab_columns col

225: */
226:
227: /* new definition bug 15932294 */
228: SELECT count(*) into l_cols_count
229: FROM all_synonyms syn, dba_tab_columns col
230: WHERE syn.table_owner = APPS_SCHEMA_NAME
231: AND syn.synonym_name = l_piv_name
232: AND col.owner = syn.table_owner AND col.table_name = syn.table_name;
233:

Line 265: FROM all_synonyms syn, dba_tab_columns col

261: */
262:
263: /* new definition bug 15932294 */
264: SELECT data_type into c_type
265: FROM all_synonyms syn, dba_tab_columns col
266: WHERE syn.table_owner = APPS_SCHEMA_NAME
267: AND syn.synonym_name = l_piv_name AND col.owner = syn.table_owner
268: AND col.table_name = syn.table_name
269: AND col.column_name = 'ATTRIBUTE'||to_char(l_cols_count-1)

Line 438: FROM all_synonyms syn, dba_tab_columns dba_cols

434: */
435:
436: /* new definition bug 15932294 */
437: SELECT data_type into l_type
438: FROM all_synonyms syn, dba_tab_columns dba_cols
439: WHERE syn.table_owner = APPS_SCHEMA_NAME
440: AND syn.synonym_name = B_TAB_NAME AND dba_cols.owner = syn.table_owner
441: AND dba_cols.table_name = syn.table_name AND dba_cols.column_name = col
442: AND rownum = 1 ;