DBA Data[Home] [Help]

APPS.FA_DELETION_PUB dependencies on FA_DISTRIBUTION_HISTORY

Line 436: FROM FA_DISTRIBUTION_HISTORY

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 );
438:
439: -- BUG# 4173695
440: -- removing this for performance and because invoice

Line 449: DELETE FROM FA_DISTRIBUTION_HISTORY

445: -- WHERE INVOICE_TRANSACTION_ID = C1_rec.INVOICE_TRANSACTION_ID_IN
446: -- OR INVOICE_TRANSACTION_ID = C1_rec.INVOICE_TRANSACTION_ID_OUT;
447: -- End Loop;
448:
449: DELETE FROM FA_DISTRIBUTION_HISTORY
450: WHERE Asset_Id = px_asset_hdr_rec.asset_id;
451:
452: DELETE FROM FA_ASSET_HISTORY
453: WHERE Asset_Id = px_asset_hdr_rec.asset_id;