DBA Data[Home] [Help]

APPS.FA_DELETION_PUB dependencies on FA_TRANSFER_DETAILS

Line 433: DELETE FROM FA_TRANSFER_DETAILS

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 );