992: primary_quantity priQty,
993: transaction_quantity txnQty,
994: overcompletion_primary_qty,
995: organization_id
996: from mtl_transactions_interface
997: where completion_transaction_id = p_cplTxnID
998: and transaction_header_id = p_txnHdrID
999: and transaction_source_id = p_wipEntityID
1000: and transaction_source_type_id = 5
1483: sysdate,
1484: mti.transaction_quantity,
1485: mti.primary_quantity,
1486: mti.transaction_date
1487: from mtl_transactions_interface mti
1488: where mti.transaction_header_id = p_txnHdrID
1489: and mti.completion_transaction_id = p_cplTxnID
1490: and mti.transaction_action_id = wip_constants.retassy_action;
1491: end if;