APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on DBA_TABLESPACES

Line 284: dba_tablespaces dt

280: decode(atp.max_trans, NULL, '', ' MAXTRANS ' || atp.max_trans),
281: dt.EXTENT_MANAGEMENT,
282: dt.ALLOCATION_TYPE
283: FROM ALL_TAB_PARTITIONS atp ,
284: dba_tablespaces dt
285: WHERE atp.table_name = p_tbl
286: AND atp.table_owner = p_owner
287: AND atp.partition_name=p_partname
288: AND atp.TABLESPACE_Name = dt.TABLESPACE_NAME;

Line 1526: dba_tablespaces dt

1522: dt.EXTENT_MANAGEMENT,
1523: dt.ALLOCATION_TYPE
1524: FROM ALL_IND_PARTITIONS ipa,
1525: ALL_INDEXES di,
1526: dba_tablespaces dt
1527: WHERE ipa.index_owner= v_msc_schema
1528: AND di.table_owner= v_msc_schema
1529: AND ipa.partition_name=cp_partname
1530: AND di.table_name= cp_tblname