APPS.PV_CONTEXT_VALUES dependencies on DBA_INDEXES

Line 3549: FROM dba_indexes a

3545: pc_pv_schema_owner IN VARCHAR2,
3546: pc_index_type IN VARCHAR2)
3547: IS
3548: SELECT a.index_name
3549: FROM dba_indexes a
3550: WHERE a.table_name = pc_mirror_table AND
3551: a.table_owner = pc_pv_schema_owner AND
3552: a.uniqueness = pc_index_type AND
3553: a.owner = pc_pv_schema_owner

Line 3632: FROM dba_indexes a

3628: pc_pv_schema_owner IN VARCHAR2)
3629: IS
3630: SELECT a.index_name, a.owner, a.tablespace_name, a.pct_free,
3631: a.uniqueness
3632: FROM dba_indexes a
3633: WHERE a.table_name = pc_table_name AND
3634: a.table_owner = pc_pv_schema_owner AND
3635: a.uniqueness = 'NONUNIQUE' AND
3636: a.owner = pc_pv_schema_owner

Line 3749: FROM dba_indexes

3745: -- in schema "PV"
3746: -- -------------------------------------------------------------------------
3747: SELECT index_name,
3748: dbms_metadata.get_ddl('INDEX', index_name, owner) ind_def
3749: FROM dba_indexes
3750: WHERE table_name = pc_table_name AND
3751: table_owner = pc_pv_schema_owner AND
3752: owner = pc_pv_schema_owner
3753: ORDER BY index_name;