DBA Data[Home] [Help]

APPS.WIP_TRANSACTIONS_PKG dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 464: delete from mtl_transaction_lots_interface

460: and transaction_type_id in (l_bind1, l_bind2, l_bind3, l_bind4) ;
461:
462: if ((completion_count1 = 0) and (completion_count2 > 0)) then
463:
464: delete from mtl_transaction_lots_interface
465: where transaction_interface_id in
466: ( select transaction_interface_id from
467: mtl_transactions_interface
468: where transaction_header_id = txn_hdr_id