APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on DBA_TABLESPACES

Line 403: dba_tablespaces dt

399: decode(atp.max_trans, NULL, '', ' MAXTRANS ' || atp.max_trans),
400: dt.EXTENT_MANAGEMENT,
401: dt.ALLOCATION_TYPE
402: FROM ALL_TAB_PARTITIONS atp ,
403: dba_tablespaces dt
404: WHERE atp.table_name = p_tbl
405: AND atp.table_owner = p_owner
406: AND atp.partition_name=p_partname
407: AND atp.TABLESPACE_Name = dt.TABLESPACE_NAME;

Line 1797: dba_tablespaces dt

1793: dt.EXTENT_MANAGEMENT,
1794: dt.ALLOCATION_TYPE
1795: FROM ALL_IND_PARTITIONS ipa,
1796: ALL_INDEXES di,
1797: dba_tablespaces dt
1798: WHERE ipa.index_owner= v_msc_schema
1799: AND di.table_owner= v_msc_schema
1800: AND ipa.partition_name=cp_partname
1801: AND di.table_name= cp_tblname