DBA Data[Home] [Help]

APPS.WF_LOCAL_SYNCH dependencies on DBA_INDEXES

Line 399: FROM dba_indexes di

395: SELECT di.OWNER,
396: di.index_name,
397: di.table_name,
398: decode(di.uniqueness, 'UNIQUE', ' UNIQUE ', ' ')
399: FROM dba_indexes di
400: WHERE di.table_owner = tableOwner
401: AND di.owner = indexOwner
402: AND di.table_name = tableName;
403:

Line 2082: FROM DBA_INDEXES

2078:
2079: CURSOR dbaIndexes(tabName varchar2,
2080: tabOwner varchar2) is
2081: SELECT INDEX_NAME
2082: FROM DBA_INDEXES
2083: WHERE TABLE_NAME = tabName
2084: AND TABLE_OWNER = tabOwner;
2085:
2086:

Line 2209: FROM DBA_INDEXES

2205:
2206: CURSOR dbaIndexes(tabName varchar2,
2207: tabOwner varchar2) is
2208: SELECT INDEX_NAME
2209: FROM DBA_INDEXES
2210: WHERE TABLE_NAME = tabName
2211: AND TABLE_OWNER = tabOwner;
2212:
2213: l_partitionID NUMBER;

Line 2366: FROM DBA_INDEXES

2362: is
2363: CURSOR dbaIndexes(tabName varchar2,
2364: tabOwner varchar2) is
2365: SELECT INDEX_NAME
2366: FROM DBA_INDEXES
2367: WHERE TABLE_NAME = tabName
2368: AND TABLE_OWNER = tabOwner;
2369:
2370: