[Home] [Help]
429:
430: -- Added transfer_header_id in the where clause
431: -- as a result of High Cost SQL drill bugfix 3116047 msiddiqu
432:
433: DELETE FROM FA_TRANSFER_DETAILS
434: WHERE ( DISTRIBUTION_ID, transfer_header_id) IN
435: ( SELECT DISTRIBUTION_ID, transaction_header_id_in transfer_header_id
436: FROM FA_DISTRIBUTION_HISTORY
437: WHERE ASSET_ID = px_asset_hdr_rec.asset_id );