DBA Data[Home] [Help]

APPS.HXC_RESTORE dependencies on HXC_TIME_ATTRIBUTES_AR

Line 1239: FROM hxc_time_attributes_ar bkupta

1235: ATTRIBUTE29,ATTRIBUTE30,BLD_BLK_INFO_TYPE_ID,OBJECT_VERSION_NUMBER,TIME_ATTRIBUTE_ID,
1236: ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,
1237: ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,
1238: ATTRIBUTE14,null,DATA_SET_ID
1239: FROM hxc_time_attributes_ar bkupta
1240: WHERE bkupta.time_attribute_id in ( SELECT /*+ NO_INDEX(temp) */
1241: master_id
1242: FROM hxc_archive_temp temp
1243: WHERE thread_id = p_thread_id )

Line 1250: FROM hxc_time_attributes_ar bkupta

1246:
1247: l_ta_count := l_ta_count + SQL%ROWCOUNT;
1248:
1249: DELETE /*+ LEADING(temp) USE_NL(bkupta) */
1250: FROM hxc_time_attributes_ar bkupta
1251: WHERE time_attribute_id IN ( SELECT /*+ NO_INDEX(temp) */
1252: master_id
1253: FROM hxc_archive_temp temp
1254: WHERE thread_id = p_thread_id )