APPS.WIP_MOVPROC_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 144

  SELECT error_column,
         error_message
    FROM wip_txn_interface_errors
   WHERE transaction_id = p_transaction_id;

Line: 177

  SELECT group_id
    INTO l_groupID
    FROM wip_move_txn_interface
   WHERE transaction_id = p_movTxnID
     AND process_phase = p_procPhase
     AND process_status = WIP_CONSTANTS.RUNNING
     AND group_id IS NOT NULL;

Line: 201

                               p_insertAssy    => fnd_api.g_true,
                               p_do_backflush  => fnd_api.g_false,
                               p_cmp_txn_id    => p_cplTxnID,
                               x_returnStatus  => x_returnStatus);

Line: 320

                               p_insertAssy    => fnd_api.g_true,
                               p_do_backflush  => fnd_api.g_true,
                               x_returnStatus  => x_returnStatus);